upgrade problem: WSN Support

WSN Support » WSN Links » upgrade problem » upgrade problem

upgrade problem

Version:

Page: 1 2

upgrade problem

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/10/04 - 10:05 AM:	#1
OK, I am using safe upgrade system. looks like my directory still functions but the upgrading directory gives this: Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 72 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 72 Warning: reset(): Passed variable is not an array or object in /home/virtual/site1/fst/var/www/html/link_directory_new/templatefunctions.p hp on line 973 Warning: Variable passed to each() is not an array or object in /home/virtual/site1/fst/var/www/html/link_directory_new/templatefunctions.p hp on line 974 it redirects me to login and when i try it kiks me out asking to login again

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6175

Posted 10/10/04 - 09:19 PM:	#2
That would normally mean something being wrong with either the database or config.php, but without the debug output I can't tell you. Place $debug = 1; at the top of the file and see what it shows.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/11/04 - 03:21 AM:	#3
$debug = 1 Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p:2) in /home/virtual/site1/fst/var/www/html/link_directory_new/prestart.php on line 110 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 20 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 22 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 20 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 22 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 20 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 22 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 20 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 22 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 20 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 22 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 73 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 73 Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p:2) in /home/virtual/site1/fst/var/www/html/link_directory_new/end.php on line 29 Warning: reset(): Passed variable is not an array or object in /home/virtual/site1/fst/var/www/html/link_directory_new/templatefunctions.p hp on line 973 Warning: Variable passed to each() is not an array or object in /home/virtual/site1/fst/var/www/html/link_directory_new/templatefunctions.p hp on line 974 that is the debug - The config file is identical to the one in working, live directory, and the live directory is running fine by itself . Edited by fresco on 10/11/04 - 03:54 AM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6175

Posted 10/11/04 - 06:33 AM:	#4
I meant inside the php, not as html. <?php $debug=1; Is your config.php properly chmoded?
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/11/04 - 09:51 AM:	#5
here we go config.php is 666 Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ; Number of rows is 114 for Resource id #19 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/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p:168) in /home/virtual/site1/fst/var/www/html/link_directory_new/prestart.php on line 110 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Warning: mysql_list_fields(): Unable to save MySQL query result in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 19 Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 21 Performing query: SELECT name,value FROM WHERE id>0 ; Table 'truefresco_org.' doesn't exist Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 72 Number of rows is for You have an error in your SQL syntax near 'WHERE id>0 ' at line 1 Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ; You have an error in your SQL syntax near 'WHERE id>0 ' at line 1 Number of rows is 24 for Resource id #26 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 ; Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hi de,lastlinktime,custom,moderators,lastedit,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 24 for Resource id #32 Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM WHERE timesent=0 ORDER BY id ASC LIMIT 0,; Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p on line 72 Number of rows is for You have an error in your SQL syntax 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/virtual/site1/fst/var/www/html/link_directory_new/classes/database.ph p:168) in /home/virtual/site1/fst/var/www/html/link_directory_new/end.php on line 29 Warning: reset(): Passed variable is not an array or object in /home/virtual/site1/fst/var/www/html/link_directory_new/templatefunctions.p hp on line 973 Warning: Variable passed to each() is not an array or object in /home/virtual/site1/fst/var/www/html/link_directory_new/templatefunctions.p hp on line 974

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6175

Posted 10/11/04 - 10:17 AM:	#6
Table 'truefresco_org.' doesn't exist Basically, your tables are undefined. If your config.php were writeable that shouldn't matter as it would create them. Edited by Paul on 10/11/04 - 10:21 AM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/11/04 - 02:57 PM:	#7
Paul wrote: Table 'truefresco_org.' doesn't exist Basically, your tables are undefined. If your config.php were writeable that shouldn't matter as it would create them. truefresco.org DOES exsist - i wrote in my original post that I am upgrading using "save method described in quantoms post" (idid my previous upgrades without a problem" and config file is exactly the same as the one in the folder "next to it" of the live directory and chmoded 666 rw-rw-rw, should i make it 777?

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6175

Posted 10/11/04 - 10:40 PM:	#8
truefresco_org. is a blank table name in a database, so it necessarily doesn't exist. I haven't tried the 'safe' upgrade method, perhaps for some reason it doesn't work anymore. The file path (which would be still set to your old directory) might come into play somewhere although I don't think it should. Try roverwriting your upgrade.php, dbschema.wsn and setup.sql in your old directory and then running the upgrade there (leaving the rest of the files old, those are the only three that matter for a db upgrade).
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/12/04 - 12:36 AM:	#9
did what you said an it worked but did this Fatal error: Call to undefined function: listlangforupgrade() in /home/virtual/site1/fst/var/www/html/link_directory/upgrade.php on line 195

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/12/04 - 12:56 AM:	#10
here is with debug on Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ; Number of rows is 264 for Resource id #18 Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/link_directory/classes/database.php:14 0) in /home/virtual/site1/fst/var/www/html/link_directory/prestart.php on line 57 Fatal error: Call to undefined function: listlangforupgrade() in /home/virtual/site1/fst/var/www/html/link_directory/upgrade.php on line 195

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/12/04 - 01:43 AM:	#11
This is what I tried to do: Created new database "test" imported backup.SQL try to run upgrade from a test folder - ERROR Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ; Number of rows is 83 for Resource id #19 Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1; Performing query: UPDATE wsnlinks_settings SET content='http://www.truefresco.org/link_directory_new' WHERE name='dirurl'; Performing query: SELECT name,value FROM WHERE id>0 ; Table 'truefresco_org_wsntest.' doesn't exist Number of rows is for You have an error in your SQL syntax near 'WHERE id>0 ' at line 1 Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ; You have an error in your SQL syntax near 'WHERE id>0 ' at line 1 Number of rows is 24 for Resource id #26 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,candofulledit,candeletecategories,candeletecomments,candeleteowncat egories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliasc ategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks ,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategori es,canhideallcomments,canratecomments,bytespermem FROM wsnlinks_membergroups WHERE id>0 ; Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hi de,lastlinktime,custom,moderators,lastedit,headerinfo,related,numsub,type,p ermissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments ,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sp onsorlinks,views,customwrap FROM wsnlinks_categories WHERE validated=1 AND hide=0 ; Number of rows is 24 for Resource id #32 Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM WHERE timesent=0 ORDER BY id ASC LIMIT 0,; Number of rows is for You have an error in your SQL syntax near 'WHERE timesent=0 ORDER BY id ASC LIMIT 0,' at line 1 and I can not login. It logs me in and throws me out. Live site does work fine but upgrade (as you suggested above) did not go pass the first step, I think it added tables and gave up. Edited by fresco on 10/12/04 - 03:17 AM

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/12/04 - 03:43 AM:	#12
also I can not view directory as visitor - it redirects to login screen? and of course wont log me in

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/12/04 - 04:22 AM:	#13
ok, I did this - upgraded from 2.55 to 2.56 went well will try to upgrade to 3.12 if will not work will go to 3.00 and so on

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/12/04 - 04:52 AM:	#14
from 256 to 3.12 did not work: still looking for same f. table as before will try to go from 2.56 to 3.00

fresco
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Posts: 106

Posted 10/12/04 - 05:13 AM:	#15
same thing - what is going on where is this table???????

Page: 1 2

You don't have permission to post.

Please login or register.