![]() ![]() |
Aug 31 2004, 10:20 AM
Post
#1
|
|
![]() Boss, my code's compiling (xkcd) Group: Admins Posts: 10,440 Joined: 19-September 01 Member No.: 1 ![]() |
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)
-------------------- ![]() ![]() Things that I don't suck at: Photography (flickr, JPG Mag), "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 |
|
|
|
Aug 31 2004, 03:57 PM
Post
#2
|
|
![]() Boss, my code's compiling (xkcd) Group: Admins Posts: 10,440 Joined: 19-September 01 Member No.: 1 ![]() |
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), "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 |
|
|
|
Aug 31 2004, 08:19 PM
Post
#3
|
|
![]() Boss, my code's compiling (xkcd) Group: Admins Posts: 10,440 Joined: 19-September 01 Member No.: 1 ![]() |
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), "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 |
|
|
|
![]() ![]() |
|
Lo-Fi Version | Time is now: 23rd May 2013 - 02:58 PM |