PDA

View Full Version : upgrade classifieds 2.3 to 2.42


rcull
December 19th, 2005, 02:17 PM
I just upgraded my classifieds and got a series of errors.:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/teambuic/public_html/classifieds/upgrade.php on line 516

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/teambuic/public_html/classifieds/upgrade.php on line 517

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/teambuic/public_html/classifieds/upgrade.php on line 524

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/teambuic/public_html/classifieds/upgrade.php on line 525

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/teambuic/public_html/classifieds/upgrade.php on line 532

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/teambuic/public_html/classifieds/upgrade.php on line 533

Warning: unlink(/home/teambuic/public_html/classifieds/login-inc.php): No such file or directory in /home/teambuic/public_html/classifieds/upgrade.php on line 547

Warning: unlink(/home/teambuic/public_html/classifieds/adm-cinc.php): No such file or directory in /home/teambuic/public_html/classifieds/upgrade.php on line 549

Warning: unlink(/home/teambuic/public_html/classifieds/adm-phpi.php): No such file or directory in /home/teambuic/public_html/classifieds/upgrade.php on line 555

Warning: unlink(/home/teambuic/public_html/classifieds/adm-purge.php): No such file or directory in /home/teambuic/public_html/classifieds/upgrade.php on line 556

Warning: unlink(/home/teambuic/public_html/classifieds/adm-cfgtpl.php): No such file or directory in /home/teambuic/public_html/classifieds/upgrade.php on line 558

Warning: unlink(/home/teambuic/public_html/classifieds/adm-cfgedit.php): No such file or directory in /home/teambuic/public_html/classifieds/upgrade.php on line 559

Upgrade complete! You can now remove the upgrade.php script.


What does this indicate, and how should I proceed?

Thanks

Chuck S
December 19th, 2005, 02:42 PM
Did you by change overwrite your config file?

It is not finding your categories and comments table. Is your table prefix entered correctly.

The file unlink errors are no problem

rcull
December 19th, 2005, 04:47 PM
I did not over right my config-inc.php or my config-int.php. The prefix appears to be correct.

I notice that I did not upload the four large .sql files. I was using cute and am using a filter which does not allow them to be seen I have now uploaded them. Should I simply run the upgrade.php again?

Thanks

Chuck S
December 19th, 2005, 05:45 PM
Well you can try to run it again and see what happens but I am wondering what is wrong with your database tables or config files etc. Note if you look at the lines your script is meantioning that it can not do.

515-517

$query = "SELECT id,catname,description,extra1,extra2,extra3,extra4,extra5,extra6 FROM {$pp_db_prefix}categories";
$resultb = mysql_query($query, $link);
while ( list( $cid, $cname, $cdesc, $e1, $e2, $e3, $e4, $e5, $e6 ) = mysql_fetch_row($resultb) ) {


523-525


$query = "SELECT id,username,comment FROM {$pp_db_prefix}comments";
$resultb = mysql_query($query, $link);
while ( list( $cid, $cname, $ccomment ) = mysql_fetch_row($resultb) ) {



531-533


$query = "SELECT id,user,title,description,extra1,extra2,extra3,extra4,extra5,extra6 FROM {$pp_db_prefix}products";
$resultb = mysql_query($query, $link);
while ( list( $cid, $cname, $ctitle, $cdesc, $e1, $e2, $e3, $e4, $e5, $e6 ) = mysql_fetch_row($resultb) ) {


There is nothing wrong with the queries they are sound. It leads me to what I asked about your config file as if the config has the proper info to make a database connection and the table prefix is right those queries will not fail


require "config-inc.php";

if ( $step == "1" ) {
print "Preparing to update 2.3 database...<p>";
// Connecting, selecting database
$link = mysql_connect("$host", "$mysql_user", "$mysql_password") or die('I cannot connect to the PhotoPost database. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]');
mysql_select_db ("$database", $link)or die("Could not connect to PhotoPost database");