No Tables created with successfull install ?

[theuniscc]

Installed successfully, then tried to upgrade from stable 0.3 to 1.0Beta4

No luck, does not create tables, even though says install was successfull.

Any ideas

[Dee]

To upgrade, don't run install, but point your browser to /install/upgrade.php (I think poiniting it to the admin will redirect to upgrade).
Upgrade doesn't create all tables again, it only makes the changes between the sql schema versions.
http://wiki.cmsmadesimple.org/index.php ... /Upgrading

[theuniscc]

To upgrade, don't run install, but point your browser to /install/upgrade.php (I think poiniting it to the admin will redirect to upgrade).
Upgrade doesn't create all tables again, it only makes the changes between the sql schema versions.
http://wiki.cmsmadesimple.org/index.php ... /Upgrading

Hi Dee
Thanks, but see other 2 posts also from me "theuniscc" I at first had stable v0.13 installed and all was fine, then I tried to install (upgrade) to ver1.0beta5.
It would not work, tried all different ways, also had hosting company try Friday afternoon and everytime cmsms says install successfull, but then the homepage is not displayed.
When I go to mysql there are no tables created. Even deleting all files etc, no luck.

Something causing tables not being created ?

[theuniscc]

I tried to use schema to create tables, but got this error.

Trying anthing to get cmsms to work again.

Error
SQL-query:

CREATE TABLE `cms_additional_htmlblob_users` (

`additional_htmlblob_users_id` int( 11 ) NOT NULL ,
`user_id` int( 11 ) default NULL ,
`htmlblob_id` int( 11 ) default NULL ,
PRIMARY KEY ( `additional_htmlblob_users_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci
MySQL said: 

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci' at line 6 

Maybe someone can assist getting cmsms up and running again.

[Dee]

How did you get that query? During CMSMS install this query is executed to create the cms_additional_htmlblob_users table:

Code: Select all

CREATE TABLE cms_additional_htmlblob_users (
additional_htmlblob_users_id INTEGER NOT NULL,
user_id                  INTEGER,
htmlblob_id              INTEGER,
PRIMARY KEY (additional_htmlblob_users_id)
)TYPE=MyISAM

(Dropping all tables and) running install using database userinfo of a mysql user with rights to create tables should be enough to create the tables needed.

[theuniscc]

How did you get that query? During CMSMS install this query is executed to create the cms_additional_htmlblob_users table:

Code: Select all

CREATE TABLE cms_additional_htmlblob_users (
additional_htmlblob_users_id INTEGER NOT NULL,
user_id                  INTEGER,
htmlblob_id              INTEGER,
PRIMARY KEY (additional_htmlblob_users_id)
)TYPE=MyISAM

(Dropping all tables and) running install using database userinfo of a mysql user with rights to create tables should be enough to create the tables needed.

I was getting desperate, so I copied the table schema from "local" install, and ran on hosting server to see if tables could be created manually, then the error.

Localhost on PC is using xampp and MySQL ver 5, my hosting server has MySQL ver 4 running, therefore the error it seems.

My Hosting company helped me today, they say that the tick mark I kept removing, during install, to avoid overwriting phpbb tables, should have been ticked. ? I must have made a mistake reading instructions, lucky I did not loose phpbb tables, as they were not dumped at the time.

Thanks for your time and help, appreciate it.

[Elijah Lofgren]

How did you get that query? During CMSMS install this query is executed to create the cms_additional_htmlblob_users table:

Code: Select all

CREATE TABLE cms_additional_htmlblob_users (
additional_htmlblob_users_id INTEGER NOT NULL,
user_id                  INTEGER,
htmlblob_id              INTEGER,
PRIMARY KEY (additional_htmlblob_users_id)
)TYPE=MyISAM

(Dropping all tables and) running install using database userinfo of a mysql user with rights to create tables should be enough to create the tables needed.

I was getting desperate, so I copied the table schema from "local" install, and ran on hosting server to see if tables could be created manually, then the error.

Localhost on PC is using xampp and MySQL ver 5, my hosting server has MySQL ver 4 running, therefore the error it seems.

You can fix that problem by choosing "MYSQL40" next to "SQL export compatibility:" when exporting out of phpMyAdmin.