Page 1 of 1

1.6 installation - error

Posted: Tue Jun 30, 2009 2:55 pm
by elliske
Creating userplugins table... [failed]

Creating version table... [failed]

Importing sample data...Invalid query: INSERT INTO cms_learning_community_version VALUES (32);

Does anyone have this experience! and know if this error is due to an incompatible mysql version?

I would be grateful for any responses!

K

Re: 1.6 installation - error

Posted: Tue Jun 30, 2009 2:59 pm
by alby
elliske wrote: Importing sample data...Invalid query: INSERT INTO cms_learning_community_version VALUES (32);
Can you run a query in your DB with a SQL tools (ex phpmyadmin?)

Try to drop that long prefix table ..... (default is cms_)


Alby

Re: 1.6 installation - error

Posted: Tue Jun 30, 2009 5:06 pm
by elliske
I will give that a try thanks for your quick response!
Is there a way to determine if this error is related to version issues of mysql since
my test install runs a much later version of mysql than the university server.

In short, does 1.6 cmsmadesimple require newer than 3.3 mysql?
thanks for your responses!
k

Re: 1.6 installation - error

Posted: Tue Jul 07, 2009 12:31 pm
by zounars
I had the same problem with 1.6 on a 1and1 share hosting but now it's solved.

I change my database version from 4 to MySQL5.0 and all work fine now

Re: 1.6 installation - error

Posted: Wed Jul 08, 2009 3:55 pm
by alby
zounars wrote: I had the same problem with 1.6 on a 1and1 share hosting but now it's solved.

I change my database version from 4 to MySQL5.0 and all work fine now
For new installation is enough 4.1 version

Alby

Re: 1.6 installation - error

Posted: Fri Jul 10, 2009 3:55 pm
by Pierre M.
alby wrote: For new installation is enough 4.1 version
Thank you for the information. I've updated http://wiki.cmsmadesimple.org/index.php ... quirements

Pierre