Menu
▾
▴
[phpesp-dev] [ phpesp-Bugs-1846497 ] Did Upgrade, Problem when Edit or Adding
|
From: SourceForge.net <no...@so...> - 2007-12-09 12:07:26
|
Bugs item #1846497, was opened at 2007-12-07 22:30 Message generated for change (Comment added) made by liedekef You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1846497&group_id=8956 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Admin Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Franky Van Liedekerke (liedekef) Summary: Did Upgrade, Problem when Edit or Adding Initial Comment: I just upgrade from 1.82 to 2.01. I did the database upgrade. Saved old version to another folder. Created same folder name for new version and update the phpESP.ini.php to reflect my old setting. The program runs, but when I try to add or edit a survey I get this error on the top of the screen-> [ Warning, error encountered. [ 1054: Unknown column 'auto_num' in 'field list' ] ] Please advise on a path to take. Thanks Chuck cc4...@ya... ---------------------------------------------------------------------- >Comment By: Franky Van Liedekerke (liedekef) Date: 2007-12-09 13:07 Message: Logged In: YES user_id=109671 Originator: NO I tested it and it is working just fine. The only difference is that in my php I don't have register_globals set and also not magic_quotes_gpc. I'll turn each of them on and try again ... Franky ---------------------------------------------------------------------- Comment By: Franky Van Liedekerke (liedekef) Date: 2007-12-09 12:52 Message: Logged In: YES user_id=109671 Originator: NO Problem 2 is easy: first, it is not an error but a php notice, you shouldn't be showing this on your screen for security reasons. Anyway, it shouldn't happen. The fix: change the name of q_id into curr_q on line 31 in admin/include/tab/questions.inc (I'll change this in CVS as well). Problem 1: still investigating ... Franky ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2007-12-09 03:18 Message: Logged In: NO Got a problem. Something is not right. I did the update of 1.82h to 1.82i. Mysql said all was fine. Seemed to work fine. Problem1 So, I created a survey, tested it. All seemed to run correctly. I then activated it. All seemed correct. The problem come when I fill out or anyone person fills out the survey. I get the backup email as I should, but when I go to look at the stat section it shows no surveys summitted. Problem2 with a newly created version I then decided it might be easier to just recreate the php program from scratch. Thus on one of my other domains and I setup the php2 from scratch. 1)I created the database in phpadmin instead of running the mysql_create.sql script. 2) I ran the mysql_populate.sql script and all ran fine without any errors. 3) I then copied the php files(leaving the file structure the same) to the server. 4) I edited the phpESP.ini.php from admin. 5) I ran the test.php from admin. All seemed ok. Here is the link if you would like to see->http://catradestationug.com/php_scripts/phpESP2/admin/test.php 6) Problem comes when I try to add a question-->>I get this error--- Notice: Undefined variable: q_id in /home/catrades/public_html/php_scripts/phpESP2/admin/include/tab/questions.inc on line 31 Any ideas. Sorry for the issues. chuck ---------------------------------------------------------------------- Comment By: Franky Van Liedekerke (liedekef) Date: 2007-12-08 23:33 Message: Logged In: YES user_id=109671 Originator: NO Yes, do run it, mysql won't mind. The only thing that happens in the file mysql_update-1.8.2h-1.8.2i.sql is the creation of that specific column. Franky ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2007-12-08 20:52 Message: Logged In: NO Yes I read the Update.txt file. I ran the update 1.82k-2.0.0. I didn't run the 1.82h to 1.82i. I know my version is 1.82, but I am not sure of the letter number. The 1.82 to 2.0.0 had no errors on the update and completed sucessfully. Should I try to run the 1.82h- to 1.82i. I don't think mysql will let me run it since the database has been updated to 2.0. Please advise. Thanks for the response. Chuck ---------------------------------------------------------------------- Comment By: Franky Van Liedekerke (liedekef) Date: 2007-12-08 16:42 Message: Logged In: YES user_id=109671 Originator: NO Hi, did you read the file called "UPDATE"? You forgot to do the DB upgrades. Go into the dir scripts/db and run the following mysql statements on your database: mysql_update-1.8.2h-1.8.2i.sql and then mysql_update-1.8.2k-2.0.0.sql Franky ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1846497&group_id=8956 |
