Support Forum

duplicate collum errors when updating 4.5.0 to 5.0.1

GI giova
giova
Member
Member since Aug 2011
25 posts
Mar 14, 2012 · 12:58 am · Edited

Greetings

 

Yesterday i’ve updated sp from 4.5.0 to 5.0.1

 

i encount lot of problems with the new version.

I checked my PHP error log and found several entries since the update was made. i’ve translated  thoses logs  :

[spoiler][13-Mar-2012 02:33:40] PHP Warning: closedir(): supplied argument is not a valid Directory resource
[13-Mar-2012 02:38:59] PHP Notice: Trying to get property of non-object
[13-Mar-2012 02:48:42] PHP Warning: closedir(): supplied argument is not a valid Directory resource
[13-Mar-2012 02:49:16] PHP Notice: Trying to get property of non-object
[13-Mar-2012 02:51:50] PHP Warning: closedir(): supplied argument is not a valid Directory resource
[13-Mar-2012 02:53:31] PHP Warning: closedir(): supplied argument is not a valid Directory resource
[13-Mar-2012 03:04:11] WordPress Database ERROR Duplicate column name ‘topic_subs’ pour la requête ALTER TABLE wp_sftopics ADD (topic_subs longtext) done with query, wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include, spa_save_plugin_list_actions, sp_activate_sp_plugin, do_action, call_user_func_array, sp_subscriptions_install, sp_subscriptions_do_install, spdb_query
[13-Mar-2012 03:04:11] WordPress Database ERROR Duplicate column name ‘subscribe’ pour la requête ALTER TABLE wp_sfmembers ADD (subscribe longtext) done with query, wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include, spa_save_plugin_list_actions, sp_activate_sp_plugin, do_action, call_user_func_array, sp_subscriptions_install, sp_subscriptions_do_install, spdb_query
[13-Mar-2012 03:04:11] WordPress Database ERROR Duplicate column name ‘use_tags’ pour la requête ALTER TABLE wp_sfforums ADD (use_tags smallint(1) NOT NULL default “1”) done with query, wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include, spa_save_plugin_list_actions, sp_activate_sp_plugin, do_action, call_user_func_array, sp_tags_install, sp_tags_do_install, spdb_query
[13-Mar-2012 03:04:11] WordPress Database ERROR Duplicate column name ‘topic_status_set’ pour la requête ALTER TABLE wp_sfforums ADD topic_status_set bigint(20) NOT NULL default 0 done with query, wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include, spa_save_plugin_list_actions, sp_activate_sp_plugin, do_action, call_user_func_array, sp_topicstatus_install, sp_topicstatus_do_install, spdb_query
[13-Mar-2012 03:04:11] WordPress Database ERROR Duplicate column name ‘topic_status_flag’ pour la requête ALTER TABLE wp_sftopics ADD topic_status_flag varchar(25) default NULL done with query, wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include, spa_save_plugin_list_actions, sp_activate_sp_plugin, do_action, call_user_func_array, sp_topicstatus_install, sp_topicstatus_do_install, spdb_query
[13-Mar-2012 03:04:11] WordPress Database ERROR Duplicate column name ‘topic_watches’ pour la requête ALTER TABLE wp_sftopics ADD (topic_watches longtext) done with query, wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include, spa_save_plugin_list_actions, sp_activate_sp_plugin, do_action, call_user_func_array, sp_watches_install, sp_watches_do_install, spdb_query
[13-Mar-2012 03:04:11] WordPress Database ERROR Duplicate column name ‘watches’ pour la requête ALTER TABLE wp_sfmembers ADD (watches longtext) done with query, wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, sp_ahah_handler, include, spa_save_plugin_list_actions, sp_activate_sp_plugin, do_action, call_user_func_array, sp_watches_install, sp_watches_do_install, spdb_query
[13-Mar-2012 03:07:57] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:30:28] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:40:29] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:40:45] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:41:01] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:41:51] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:42:58] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:43:22] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:44:41] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ‘UTC 1’ is invalid
[13-Mar-2012 03:44:41] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ‘UTC 1’ is invalid
[13-Mar-2012 03:44:41] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ‘UTC 1’ is invalid
[13-Mar-2012 03:45:06] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ‘UTC 1’ is invalid
[13-Mar-2012 03:45:06] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ‘UTC 1’ is invalid
[13-Mar-2012 03:45:06] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ‘UTC 1’ is invalid
[13-Mar-2012 03:45:33] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ” is invalid
[13-Mar-2012 03:45:33] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ” is invalid
[13-Mar-2012 03:47:14] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:47:33] PHP Notice: Trying to get property of non-object
[13-Mar-2012 03:50:57] PHP Notice: Trying to get property of non-object
[13-Mar-2012 04:09:24] PHP Notice: Trying to get property of non-object
[13-Mar-2012 04:33:27] PHP Notice: Trying to get property of non-object
[13-Mar-2012 04:45:19] PHP Notice: Trying to get property of non-object
[13-Mar-2012 04:45:28] PHP Notice: Trying to get property of non-object
[13-Mar-2012 04:47:34] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:05:28] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:06:00] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:06:06] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:06:31] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:06:42] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:07:32] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:07:45] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:08:25] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ” is invalid
[13-Mar-2012 05:08:25] PHP Notice: date_default_timezone_set() [<a href=’function.date-default-timezone-set’>function.date-default-timezone-set</a>]: Timezone ID ” is invalid
[13-Mar-2012 05:10:48] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:11:06] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:14:03] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:15:22] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:16:15] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:16:56] PHP Notice: Trying to get property of non-object
[13-Mar-2012 05:54:26] PHP Notice: Trying to get property of non-object
[13-Mar-2012 06:35:56] PHP Notice: Trying to get property of non-object
[13-Mar-2012 06:36:17] PHP Notice: Trying to get property of non-object[/spoiler]

does thoses errors speaks to you?

here my environment : 

[spoiler]

 

Simple:Press   Version: 5.0.1
Build: 8048
Release: Release
WordPress   Version: 3.3.1
Langue: fr-FR
Jeu de caractères: UTF-8
Thème: FAM
PHP   Version: 5.2.17
Mémoire: 512M
Téléchargement Max (Max Upload): 2M
Attente de réponse (Timeout):
MySQL   Version: 5.1.61
Préfix(e): wp_
Serveur   Version: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Extensions WP   All in One SEO Pack (1.6.13.8)
Contact Form 7 (3.1.1)
Featured Posts Scroll (1.25)
Google XML Sitemaps (3.2.6)
Menubar (4.10)
Minimum comment length (1.0.1)
Really Simple CAPTCHA (1.5)
s2Member (111206)
SABRE (1.2.0)
Shortcode Exec PHP (1.41)
Simple:Press (5.0.1)
WordPress Download Monitor (3.3.5.4)
WordPress HTTPS (2.0.4)
WP-Polls (2.62)
WP Easy Paypal Payment Accept (v2.6)
WP Maintenance Mode (1.7.1)
WP Smush.it (1.5.0)
WP YouTube Lyte (1.0.0)
Zerby Login Widget (0.4)
Extensions SP   Blog Post Linking (1.0.12)
Custom Profile Fields (1.0.7)
Editor (TinyMCE – Rich Text) (1.0.4)
Google XML Sitemap (1.0.2)
Private Message System (1.0.17)
Profile Display Control (1.0.2)
Report Post (1.0.6)
Subscriptions (1.0.12)
Tags (1.0.10)
Template Tags and Widgets (1.0.9)
Topic Status (1.0.6)
Watches (1.0.13)
Who’s Online (1.0.6)

 

[/spoiler]

5 Answers

New Answer
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Mar 14, 2012 · 5:06 am

The only concern I have there is probably the closedir() message. The rest are safe – nuisance value but safe. All of the DB messages relate to activating plugins during an upgrade and at the moment unavoidable but they are just warning not errors as such.

My main concern is that you say you are encountering a lot of problems with V5. Can you tell me what they are please so we can help?

GI giova
giova
Member
Member since Aug 2011
25 posts
Mar 14, 2012 · 2:53 pm

Thank you for replying.

 

Well there is an other big problem shown by this log.

Before the update my error log was empty.

Now my error log is growing each hour. here the 10 last lines :

[spoiler][14-Mar-2012 18:05:45] PHP Notice: Trying to get property of non-object
[14-Mar-2012 18:09:36] PHP Notice: Trying to get property of non-object
[14-Mar-2012 18:11:29] PHP Notice: Trying to get property of non-object
[14-Mar-2012 18:13:08] PHP Notice: Trying to get property of non-object
[14-Mar-2012 18:13:49] PHP Notice: Trying to get property of non-object
[14-Mar-2012 18:14:42] PHP Notice: Trying to get property of non-object
[14-Mar-2012 18:17:54] PHP Notice: Trying to get property of non-object
[14-Mar-2012 18:43:00] PHP Notice: Trying to get property of non-object
[14-Mar-2012 19:25:43] PHP Notice: Trying to get property of non-object
[14-Mar-2012 19:39:40] PHP Notice: Trying to get property of non-object
[14-Mar-2012 19:39:51] PHP Notice: Trying to get property of non-object[/spoiler]

i absolutly need to fix this asap, or i’ll have no other choice than get back to the previous release confused

 

Regarding other problems i’ll make new topics, or replies in existing topics, for each one to not make this topic a huge hugger-mugger.

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Mar 14, 2012 · 4:12 pm

we plan to get an update out in a few days to correct these which were an unintended side effect of a different fix. If you feel it is urgent would it be useful at all if I gave you links to the changesets so you could make the corrections needed? I believe mostly they are small.

GI giova
giova
Member
Member since Aug 2011
25 posts
Mar 14, 2012 · 4:56 pm

no problem Yellow Swordfish i can wait couple of days.

 

This is just that i can’t stay with an errorlog growing all the time, and more i wait, more the task to get back to the previous release would be long….

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Mar 14, 2012 · 5:47 pm

Fingers crossed – wont be long to wait.