Main Menu
collapse

Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

User Info

Welcome Guest.
Please log in.

Who's Online

  • Dot Guests: 748
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]


If you're interested in helping other members with support requests, consider joining the Community Support Helpers group.

mysql_free_result() expects parameter 1 to be resource, null given

Started by dhayzon, April 27, 2013, 01:16:50 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


Old Fossil

Rather than use an image which doesn't explain what problems you are experiencing would you please give us more information.

Daily backups mean less headaches

Block Set Up

I may be no coding expert but I am willing to help where I can.

I eat Spammers for breakfast

andy

1. Is free_result() part of SMF or S'portal or some mod you have - I dont know without spending time testing/checking.

2. You error relates to 2 different database language collocation  types. How that came to be set that way - that is worth checking. You could set one so that it is the same as the others and test it.

Everyone is a volunteer here so please try and make a small donation to keep the Simple Portal website running


Chen Zhen

igirisjin,

  Good thing you spotted the bottom image regarding collation because I missed that when I first read this thread yesterday.

dhayzon,

  I made a tool for SMF to fix collation issues a while back that you can try.
Make sure to backup your database prior to using it to be safe.

Here is the thread with the needed application(s):
http://askusaquestion.net/index.php/topic,3623.0.html

v1.0 will set the collation & engine type for all tables & columns to match your SMF settings table.
v1.1 will set the collation & engine type for all tables & columns to match the overall database setting.

Try v1.0 first which will only fail if your database name contains a hyphen. If it does fail then use v1.1 which will work no matter what. Both will work for utf8 type encoding or compatible.   

ccbtimewiz

The error is actually not with freeing the result, but rather the result did not fill up properly and freeing it resulted in the error you see...

Looking at Subs-Portal.php with that specific line, it's in the sportal_get_shouts function when it's fetching the shouts from the database.

Of course the problem in of itself could stem from a bad installation, I don't have enough information to help you. Are there any other errors? Does your shoutbox work?