Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
duplicate collum errors when updating 4.5.0 to 5.0.1
Avatar
giova
Member
Free Members
sp_UserOfflineSmall Offline
Mar 14, 2012 - 12:58 am

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  :

[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

does thoses errors speaks to you?

here my environment : 

 

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)

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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?

andy-signature.png
YELLOW
SWORDFISH
Avatar
giova
Member
Free Members
sp_UserOfflineSmall Offline
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 :

[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

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.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
giova
Member
Free Members
sp_UserOfflineSmall Offline
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....

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 14, 2012 - 5:47 pm

Fingers crossed - wont be long to wait.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626