[phpesp-dev] [ phpesp-Bugs-1846497 ] Did Upgrade, Problem when Edit or Adding

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Bugs item #1846497, was opened at 2007-12-07 16:30
Message generated for change (Comment added) made by greggmc
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: Matthew Gregg (greggmc)
Date: 2007-12-09 15:49

Message:
Logged In: YES 
user_id=14116
Originator: NO

FYI phpESP should never work with globals on

----------------------------------------------------------------------

Comment By: Franky Van Liedekerke (liedekef)
Date: 2007-12-09 07:11

Message:
Logged In: YES 
user_id=109671
Originator: NO

Sorry, but your error is not reproducible here ... please provide error
logs if any.

Franky

----------------------------------------------------------------------

Comment By: Franky Van Liedekerke (liedekef)
Date: 2007-12-09 07: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 06: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-08 21: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 17: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 14: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 10: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