CyberiaPC.com Community Forums Main Page
RSS Feeds: Late(st) News | Zenith Picture Gallery | Most Recent Community Topics | Tips, Tricks and Other Useful Stuff

Welcome Guest ( Log In | Register )

 Forum Rules Also hosted on SourceForge and FreshMeat
Reply to this topicStart new topic
> [0.6] Warnings after a v0.4.x -> v0.6 upgrade
usr.c
post Aug 31 2004, 10:20 AM
Post #1


Boss, my code's compiling (xkcd)
Group Icon

Group: Admins
Posts: 10,440
Joined: 19-September 01
Member No.: 1

Nothing Selected




Problem: MySQL warnings following an upgrade from v0.4.x to v0.6 and Admin CP functions don't all work.
Reproduction: See attachment
Solution : Run upgrader2.php as well as upgrader1.php from the installation package.
Updated solution: See next post!


This problem is caused by not running upgrader2.php following an upgrade from v0.4.x to v0.6, which adds a new field 'description' to the pictures table and a new field 'downloadable' to the categories table. When these fields are missing, the queries that are executed in the code fail since they contain unknown fields.

If you are still unable to resolve the problem, could you please post a reply in this topic with your server information and the exact steps you took before getting the warnings.
Attached image(s)
Attached Image
 


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


Things that I don't suck at: Photography (flickr, JPG Mag), Skydiving, Splitting atoms, Flying a space shuttle
"Don't bail; the best gold is at the bottom of barrels of crap!" -Randy Pausch
I have people-skills goddamnit! What is wrong with you people!!! | www.skyrill.com
Go to the top of the page
 
+Quote Post
usr.c
post Aug 31 2004, 03:57 PM
Post #2


Boss, my code's compiling (xkcd)
Group Icon

Group: Admins
Posts: 10,440
Joined: 19-September 01
Member No.: 1

Nothing Selected




The problem turned out to be more critical for MySQL version 3.22.x/3.23.x users. Either it is the query caching or something else in MySQL server 4.x, but it did not display any of the problems that were being displayed on the former.

If you receive the errors mentioned above and various other errors in the Admin CP, please download the v0.6 package again from http://cyberiapc.com/forums/index.php?act=...e=post&id=25156

I have updated it as of August 31, 3:53PM GMT.

I will go through the entire code tonight and ensure that every part of it is compatible with MySQL server version 3.22.x/3.23.x and release the updated package as v0.6.1 first thing tomorrow morning.

I apologize for any headaches this may have caused you.


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


Things that I don't suck at: Photography (flickr, JPG Mag), Skydiving, Splitting atoms, Flying a space shuttle
"Don't bail; the best gold is at the bottom of barrels of crap!" -Randy Pausch
I have people-skills goddamnit! What is wrong with you people!!! | www.skyrill.com
Go to the top of the page
 
+Quote Post
usr.c
post Aug 31 2004, 08:19 PM
Post #3


Boss, my code's compiling (xkcd)
Group Icon

Group: Admins
Posts: 10,440
Joined: 19-September 01
Member No.: 1

Nothing Selected




Please download the v0.6.1 package at the same link and post a reply here if you still receive errors, which should all be fixed now.


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


Things that I don't suck at: Photography (flickr, JPG Mag), Skydiving, Splitting atoms, Flying a space shuttle
"Don't bail; the best gold is at the bottom of barrels of crap!" -Randy Pausch
I have people-skills goddamnit! What is wrong with you people!!! | www.skyrill.com
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 23rd May 2013 - 02:58 PM