Hi, I followed the instructions to upgrade from 2.5 to 3.13, but when attempting to access the admin I get this error:
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
I followed the upgrade instructions in the readme.htmlfile, however, when I attempt to login to the admin and run the upgrade, I get this error:
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 82
Warning: reset(): Passed variable is not an array or object in /home/clickfir/public_html/directory/templatefunctions.php on line 972
Warning: Variable passed to each() is not an array or object in /home/clickfir/public_html/directory/templatefunctions.php on line 973
I'm unable to get the debug on. Will I have to write a query to get the debug on or is there another alternative without having access to the admin?
Here's the Debug info when attempting to access the root index.php. Any interpretations?:
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Warning: Cannot modify header information - headers already sent by (output started at /home/clickfir/public_html/directory/classes/database.php:230) in /home/clickfir/public_html/directory/prestart.php on line 115
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Getting field list for table
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Getting field list for table
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Getting field list for table
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Getting field list for table
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Load time so far: 0.12 seconds. Performing query: SELECT name,value FROM WHERE id>0 ;
Table 'clickfir_wsnlinks.' doesn't exist
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 82
Number of rows is for You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id>0' at line 1
Load time so far: 0.12 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id>0' at line 1
Number of rows is 22 for Resource id #26
Load time so far: 0.12 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecat s,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcate gories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncom ments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,can emailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,cande leteall FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.12 seconds. Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,ema il,validated,template,language,lastattempt,allowemail,signature,avatarname, stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Load time so far: 0.13 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hi de,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,p ermissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 22 for Resource id #31
Load time so far: 0.13 seconds. Performing query: LOCK TABLES WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.13 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM WHERE timesent=0 ORDER BY id ASC LIMIT 0,;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlin
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 82
Number of rows is for You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timesent=0 ORDER BY id ASC LIMIT 0,' at line 1
Load time so far: 0.13 seconds. Performing query: UNLOCK TABLES;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timesent=0 ORDER BY id ASC LIMIT 0,' at line 1
Warning: Cannot modify header information - headers already sent by (output started at /home/clickfir/public_html/directory/classes/database.php:230) in /home/clickfir/public_html/directory/commonfuncs.php on line 317
Load time so far: 0.13 seconds. Performing query: UPDATE wsnlinks_settings SET content='1105233582' WHERE name='lastrotation';
Load time so far: 0.14 seconds. Performing query: UPDATE wsnlinks_settings SET content='' WHERE name='currentletter';
Load time so far: 0.14 seconds. Performing query: UPDATE wsnlinks_links SET hitsouttemp='0' WHERE id>0;
Load time so far: 0.14 seconds. Performing query: UPDATE wsnlinks_links SET hitsintemp='0' WHERE id>0;
Unknown column 'hitsouttemp' in 'field list'
Load time so far: 0.14 seconds. Performing query: UPDATE wsnlinks_settings SET content='1105233582' WHERE name='hitstempreset';
Unknown column 'hitsintemp' in 'field list'
Load time so far: 0.14 seconds. Performing query: UPDATE wsnlinks_settings SET content='1105233582' WHERE name='staticexporttime';
Load time so far: 0.14 seconds. Performing query: SELECT id FROM wsnlinks_members WHERE validated=1 ;
Number of rows is 722 for Resource id #33
Load time so far: 0.15 seconds. Performing query: UPDATE wsnlinks_settings SET content='722' WHERE name='totalmembers';
Load time so far: 0.15 seconds. Performing query: UPDATE wsnlinks_settings SET content='1105233582' WHERE name='debittime';
Load time so far: 0.15 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hi de,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,p ermissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,75;
Number of rows is 11 for Resource id #35
Load time so far: 0.15 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ;
Number of rows is 11 for Resource id #36
Warning: Cannot modify header information - headers already sent by (output started at /home/clickfir/public_html/directory/classes/database.php:230) in /home/clickfir/public_html/directory/commonfuncs.php on line 317
Warning: Cannot modify header information - headers already sent by (output started at /home/clickfir/public_html/directory/classes/database.php:230) in /home/clickfir/public_html/directory/end.php on line 29
Warning: reset(): Passed variable is not an array or object in /home/clickfir/public_html/directory/templatefunctions.php on line 972
Warning: Variable passed to each() is not an array or object in /home/clickfir/public_html/directory/templatefunctions.php on line 973
Comments on Upgrade Error 2.5 to 3.13
Member
Usergroup: Customer
Joined: Nov 11, 2003
Total Topics: 9
Total Comments: 21
Hi, I followed the instructions to upgrade from 2.5 to 3.13, but when attempting to access the admin I get this error:
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
I followed the upgrade instructions in the readme.htmlfile, however, when I attempt to login to the admin and run the upgrade, I get this error:
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 82
Warning: reset(): Passed variable is not an array or object in /home/clickfir/public_html/directory/templatefunctions.php on line 972
Warning: Variable passed to each() is not an array or object in /home/clickfir/public_html/directory/templatefunctions.php on line 973
I'm unable to get the debug on. Will I have to write a query to get the debug on or is there another alternative without having access to the admin?
Thanks,
Emory
Member
Usergroup: Customer
Joined: Nov 11, 2003
Total Topics: 9
Total Comments: 21
Here's the Debug info when attempting to access the root index.php. Any interpretations?:
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Warning: Cannot modify header information - headers already sent by (output started at /home/clickfir/public_html/directory/classes/database.php:230) in /home/clickfir/public_html/directory/prestart.php on line 115
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Getting field list for table
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Getting field list for table
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Getting field list for table
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Getting field list for table
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/clickfir/public_html/directory/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 31
Load time so far: 0.12 seconds.
Performing query: SELECT name,value FROM WHERE id>0 ;
Table 'clickfir_wsnlinks.' doesn't exist
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 82
Number of rows is for You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id>0' at line 1
Load time so far: 0.12 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id>0' at line 1
Number of rows is 22 for Resource id #26
Load time so far: 0.12 seconds.
Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecat s,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcate gories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncom ments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,can emailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,cande leteall FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.12 seconds.
Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,ema il,validated,template,language,lastattempt,allowemail,signature,avatarname, stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Load time so far: 0.13 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hi de,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,p ermissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 22 for Resource id #31
Load time so far: 0.13 seconds.
Performing query: LOCK TABLES WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.13 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM WHERE timesent=0 ORDER BY id ASC LIMIT 0,;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlin
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/clickfir/public_html/directory/classes/database.php on line 82
Number of rows is for You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timesent=0 ORDER BY id ASC LIMIT 0,' at line 1
Load time so far: 0.13 seconds.
Performing query: UNLOCK TABLES;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timesent=0 ORDER BY id ASC LIMIT 0,' at line 1
Warning: Cannot modify header information - headers already sent by (output started at /home/clickfir/public_html/directory/classes/database.php:230) in /home/clickfir/public_html/directory/commonfuncs.php on line 317
Load time so far: 0.13 seconds.
Performing query: UPDATE wsnlinks_settings SET content='1105233582' WHERE name='lastrotation';
Load time so far: 0.14 seconds.
Performing query: UPDATE wsnlinks_settings SET content='' WHERE name='currentletter';
Load time so far: 0.14 seconds.
Performing query: UPDATE wsnlinks_links SET hitsouttemp='0' WHERE id>0;
Load time so far: 0.14 seconds.
Performing query: UPDATE wsnlinks_links SET hitsintemp='0' WHERE id>0;
Unknown column 'hitsouttemp' in 'field list'
Load time so far: 0.14 seconds.
Performing query: UPDATE wsnlinks_settings SET content='1105233582' WHERE name='hitstempreset';
Unknown column 'hitsintemp' in 'field list'
Load time so far: 0.14 seconds.
Performing query: UPDATE wsnlinks_settings SET content='1105233582' WHERE name='staticexporttime';
Load time so far: 0.14 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE validated=1 ;
Number of rows is 722 for Resource id #33
Load time so far: 0.15 seconds.
Performing query: UPDATE wsnlinks_settings SET content='722' WHERE name='totalmembers';
Load time so far: 0.15 seconds.
Performing query: UPDATE wsnlinks_settings SET content='1105233582' WHERE name='debittime';
Load time so far: 0.15 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hi de,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,p ermissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,75;
Number of rows is 11 for Resource id #35
Load time so far: 0.15 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ;
Number of rows is 11 for Resource id #36
Warning: Cannot modify header information - headers already sent by (output started at /home/clickfir/public_html/directory/classes/database.php:230) in /home/clickfir/public_html/directory/commonfuncs.php on line 317
Warning: Cannot modify header information - headers already sent by (output started at /home/clickfir/public_html/directory/classes/database.php:230) in /home/clickfir/public_html/directory/end.php on line 29
Warning: reset(): Passed variable is not an array or object in /home/clickfir/public_html/directory/templatefunctions.php on line 972
Warning: Variable passed to each() is not an array or object in /home/clickfir/public_html/directory/templatefunctions.php on line 973
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Have a look at your config.php file, compare it to the default one. It seems like you're missing a whole bunch of table names.
I'm guessing you didn't chmod your config.php when upgrading. You'll need to chmod it to 666 and re-run the upgrade.