Support ⇒ Upgrades :: Archives ⇒ [fixed] 9.2 RC2 Table already exists :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexUpgrades

Archived ⇒ [fixed] 9.2 RC2 Table already exists


While I was updating the latest CVS 9.1.2.81 or whatever it was to the CVS of 9.2.0 or whatever it is now, I got an error on update on step "Build database" after Executing the queries:
On /000.pri.ee/Dragonfly CVS/concurrent versioning system/install.php While executing query "CREATE TABLE cms_users ( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, name VARCHAR(60) NULL DEFAULT '', username VARCHAR(50) NOT NULL DEFAULT '', user_email VARCHAR(255) NOT NULL DEFAULT '', femail VARCHAR(255) NULL DEFAULT '', user_website VARCHAR(255) NULL DEFAULT '', user_avatar VARCHAR(255) NOT NULL DEFAULT '', user_regdate INT NOT NULL DEFAULT '0', user_icq VARCHAR(15) NULL DEFAULT '', user_occ VARCHAR(100) NULL DEFAULT '', user_from VARCHAR(100) NULL DEFAULT '', user_interests VARCHAR(150) NULL DEFAULT '', user_sig TEXT NULL, user_viewemail BOOL NOT NULL DEFAULT '0', user_aim VARCHAR(35) NULL DEFAULT '', user_yim VARCHAR(40) NULL DEFAULT '', user_skype VARCHAR(40) NULL DEFAULT '', user_msnm VARCHAR(40) NULL DEFAULT '', user_password VARCHAR(40) NOT NULL DEFAULT '', storynum TINYINT NOT NULL DEFAULT '10', umode VARCHAR(10) NULL DEFAULT '', uorder TINYINT NOT NULL DEFAULT '0', thold TINYINT NOT NULL DEFAULT '0', noscore TINYINT NOT NULL DEFAULT '0', bio TEXT NULL, ublockon TINYINT NOT NULL DEFAULT '0', ublock TEXT NULL, theme VARCHAR(255) NOT NULL DEFAULT '', commentmax INT NOT NULL DEFAULT '4096', counter INT NOT NULL DEFAULT '0', newsletter TINYINT NOT NULL DEFAULT '0', user_posts INT NOT NULL DEFAULT '0', user_attachsig TINYINT NOT NULL DEFAULT '1', user_rank INT NOT NULL DEFAULT '0', user_level TINYINT NOT NULL DEFAULT '1', user_active TINYINT NULL DEFAULT '1', user_session_time INT NOT NULL DEFAULT '0', user_lastvisit INT NOT NULL DEFAULT '0', user_timezone VARCHAR(6) NOT NULL DEFAULT '0', user_dst SMALLINT NOT NULL DEFAULT '0', user_style TINYINT NULL DEFAULT '0', user_lang VARCHAR(255) NOT NULL DEFAULT 'english', user_dateformat VARCHAR(14) NOT NULL DEFAULT 'D M d, Y g:i a', user_new_privmsg SMALLINT NOT NULL DEFAULT '0', user_unread_privmsg SMALLINT NOT NULL DEFAULT '0', user_last_privmsg INT NOT NULL DEFAULT '0', user_emailtime INT NULL DEFAULT '0', user_allowhtml BOOL NULL DEFAULT '1', user_allowbbcode BOOL NULL DEFAULT '1', user_allowsmile BOOL NULL DEFAULT '1', user_allowavatar BOOL NOT NULL DEFAULT '1', user_allow_pm BOOL NOT NULL DEFAULT '1', user_allow_viewonline BOOL NOT NULL DEFAULT '1', user_notify BOOL NOT NULL DEFAULT '0', user_notify_pm BOOL NOT NULL DEFAULT '0', user_popup_pm BOOL NOT NULL DEFAULT '0', user_avatar_type TINYINT NOT NULL DEFAULT '3', user_actkey VARCHAR(32) NULL DEFAULT '', user_newpasswd VARCHAR(32) NULL DEFAULT '', user_group_cp INT NOT NULL DEFAULT '2', user_group_list_cp VARCHAR(100) NOT NULL DEFAULT '2', user_active_cp BOOL NOT NULL DEFAULT '1', susdel_reason TEXT NULL, PRIMARY KEY (user_id), KEY uname (username), KEY user_session_time (user_session_time), KEY user_regdate (user_regdate), KEY user_email (user_email), KEY user_id_level (user_id, user_level), KEY user_active_level (user_active, user_level) ) TYPE=MyISAM DEFAULT CHARSET=utf8" the following error occured: Table 'cms_users' already exists In: D:\Madis\Veeb\000.pri.ee\Dragonfly CVS\concurrent versioning system\includes\classes\installer.php on line: 61
Should I try the release in Downloads, or the bug probably exists there too?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
-


Do you have a shared user tale for different installations?
Do you have other tables into the same db?

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Mhm, I repaired and optimized the tables and it updated fine now!

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
-


Eestlane wrote
Mhm, I repaired and optimized the tables and it updated fine now!

So i guess i should run the OPTIMIZE TABLE query before and after the installer starts the upgrade.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


I guess my table was broken before, but I'm not sure.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
-

All times are UTC