I am trying to upgrade from 135 to 143.
I am following the instruction in the doco word by word and still having no luck at all.
When i run the update.php the results say Already Done, and the last 10-15 lines are blank (results say already done).
When i then try to continue (checkversion or front page) all i get is Fatal Error:
Any help would be appreciated.
make sure you replaced all needed files, make sure you have uploaded using the proper FTP mode, make sure you mySQL user has ALTER permissions, post a link for details
yeah i saw an earlier post about the ALTER and made sure of that one...
www.stilgs.com
You haven't done as suggested, looking at your HTML output clearly shows that you're using cpg1.3.5 code. Re-read the upgrade section again and do as suggested. Make sure to not only replace the files in coppermine's root folder, but the files in the sub-folders (particularly the include folder) as well.
sorry about that... after i got the fatal error... i restored old files to get i working again..
Enable debug mode to get a more descriptive error message.
I am getting this same error, and I have followed the directions... I am upgrading from 1.3.5 to 1.4.3, and as of now nothing works, thankfully this is a backup but still...I am not happy, I can't upgrade at all... I can't side grade, and as far as I can tell I can't do squat... I need help and I'm getting lost in the process...
This is what I am reading...
http://www.cyberpawz.com/Coppermine2/docs/index.htm#13
And this is what I get as results...
http://www.cyberpawz.com/Coppermine2/
Something isn't right in Denmark, and it's not me. On that note, whenever I do the update.php it seems for some reason the updates aren't taking, but all folders and subfolders, and files have the CHMOD of 777
http://www.cyberpawz.com/Coppermine2/versioncheck.php
Oh, and this is what my database looks like now...thankfully it hasn't messed up the old server at all... and I do have backups thankfully even if it did.
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.cyberpawz.com%2Fimages%2FPicture1.jpg&hash=e763c96f0e296a2193f95384dcb52f7757c04676)
Okay have tried the update with the debug mode on. This is what i get on the page as well as Fatal error:
While executing query "delete from `cpg135`.cpg135_sessions where time<1140471913 and remember=0;" on Resource id #6
mySQL error: Table 'cpg135.cpg135_sessions' doesn't exist
I havent restored back to the old working site, so you can check it out if you want... www.stilgs.com
Ta
Give your mysql user the CREATE privilege and run the update.php again.
Just double checked and my sql user has ALL priveledges for my database.
Looks like the MySQL dot in the database name problem. Do you agree, Nibbler?
That dot is supposed to be there, it separates the db name from the table name. The problem is when there is a dot in the db name itself.
Something's adding extra single quotes to the queries like this:
INSERT INTO cpg135_filetypes VALUES (''jpg'', ''image/jpg'', ''image'', '''')
which causes the queries to fail due to bad syntax, it should of course be like this.
INSERT INTO cpg135_filetypes VALUES ('jpg', 'image/jpg', 'image', '')
A presumably similar problem has caused the file to not be split up into queries properly which is why the output of update.php looks incomplete.
The update.sql (http://www.stilgs.com/sql/update.sql) file is correct however, so I suspect something odd with your php setup that may be the same issue as http://forum.coppermine-gallery.net/index.php?topic=27586.0 and http://forum.coppermine-gallery.net/index.php?topic=23584.0
Is there a way to see if php was compiled with the --with-pcre-regex option?
It will show on a phpinfo()
ah okay it has
'--with-pcre-regex=/usr'
That's the issue then, contact your local server admin.
its my server :)
That's convenient then.
the joys of self-hosting ;D
Quote from: Nibbler on February 20, 2006, 11:51:27 PM
Give your mysql user the CREATE privilege and run the update.php again.
It does, and it still doesn't work.
This thread deals with another issue, the original guess that the mySQL permissions weren't sufficient turned out to be false. This thread deals with a compilation issue. If you have similar issues (that is: similar symptoms), then start your own thread.