php errors after migrating to new host

New Member Joined: Jul 28, 2007 Posts: 14

Hi all

I recently changed hosts the only thing i did was completely backup nuke and db and then add to temporary domain until nameservers are live, i resored database and uploaded all files but get this error on entry to index.php

Fatal error: Call to a member function on a non-object in **path removed by admin**/index.php on line 38

line 38 as follows

Code:

$row = $db->sql_fetchrow($db->sql_query('SELECT main_module from '.$prefix.'_main'));

any ideas????

thanks in advance

EH[/code]

Posted: Mon May 12, 2008 12:37 pm

in main_module in the sql it does state on index defined? is this normal if not what is the default index supposed to be?

Posted: Mon May 12, 2008 12:54 pm

My first thought is that there may be something screwy with your config.php - specifically with the database connection. DO NOT POST YOUR CONFIG.PHP here...

Double checking my first thought, came across a similar error on google at
[ Only registered users can see links on this board! Get registered or login! ]

references an issue with the database, so it sounds plausible. . .

I would check to see that you have changed your database settings to point to the new server (it's usually localhost, but you never can tell)

-sting

Posted: Mon May 12, 2008 1:02 pm

yeah its localhost and its changed, running out of ideas lol

Posted: Mon May 12, 2008 8:20 pm

$dbtype should be defined as MySQL and all the files in the db folder should be there.

Just to confirm, you are using v2.10.01?

Posted: Tue May 13, 2008 12:39 am

evaders99 wrote:

$dbtype should be defined as MySQL and all the files in the db folder should be there.

Just to confirm, you are using v2.10.01?

yes its 2.10.01 and i check that and all seems to be in the sql file no errors on import??

Posted: Tue May 13, 2008 12:10 pm

evaders99 wrote:

$dbtype should be defined as MySQL and all the files in the db folder should be there.

Just to confirm, you are using v2.10.01?

yes its 2.10.01 and i check that and all seems to be in the sql file no errors on import??

Posted: Tue May 13, 2008 12:13 pm

hasn't aybody got any ideas??? im really stuck now and site already been down for 2 days?

Posted: Tue May 13, 2008 2:12 pm

Are you able to access your database through a separate php file? Maybe running a select * on one of the tables just to see if you can get a response?

-sting

Posted: Tue May 13, 2008 2:33 pm

sure forums link gives me this

Warning: mysql_query() [function.mysql-query]: Access denied for user '1337-elite.co.uk'@'localhost' (using password: NO) in **path removed by admin**/modules/RWS_WhoIsWhere/includes/RWS_wiw.inc.php on line 49

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in **path removed by admin**/modules/RWS_WhoIsWhere/includes/RWS_wiw.inc.php on line 49
MySQL said: Access denied for user '**removed by admin**' (using password: NO)

[ Only registered users can see links on this board! Get registered or login! ]

which is wierd cause config doesnt have that user details??

Posted: Tue May 13, 2008 4:31 pm

if anyone seriously knows how to fix this please contact me urgently i am willing to pay money for someone to restore my database and nuke to fully operational again

Posted: Tue May 13, 2008 9:25 pm

phpNuke should be defining those values from config.php. RWS_WhoIsWhere does use the standard mysql functions rather than the abstraction layer, which may be causing the problem

Posted: Wed May 14, 2008 12:49 am

evaders99 wrote:

phpNuke should be defining those values from config.php. RWS_WhoIsWhere does use the standard mysql functions rather than the abstraction layer, which may be causing the problem

ok so what would be the fix??

Posted: Wed May 14, 2008 6:18 am

elite_haxor, please, please, please stop posting your full path information and you even provided your mysql user id! <sigh> That is only hurting you as it exposes very sensitive information out in a public realm.

Try shutting off your who is where block as well as inactivate the module. First try that.

However, second, try commenting out the following code in index.php and in modules.php:

Code:




include_once('modules/RWS_WhoIsWhere/includes/RWS_wiw.inc.php');

Don't do these all at once. Try one at a time progressively... This will rule in/out the WhoIsWhere causing the issue.

Posted: Sat May 17, 2008 11:05 am

its fine but thanks, i managed to figure out what was wrong, my ftp client basically decided not to transfer some files correctly and missed mainfile.php and some other so i re-upped those only to get mysql errors but im quite good with sql so just re added all the tables it missed in the restoration ; )

Posted: Sat May 17, 2008 11:32 am

Ok. Thanks for letting us know. Good luck!