Data Base Error

[June]

I have tried clean install for test site,

I got the following message.


I am not sure what this means.
What I should do next?
Please give help!

Database error in vBulletin :
Invalid SQL:
CREATE TABLE post (
postid INT UNSIGNED NOT NULL AUTO_INCREMENT,
threadid INT UNSIGNED NOT NULL DEFAULT '0',
parentid INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(100) NOT NULL DEFAULT '',
userid INT UNSIGNED NOT NULL DEFAULT '0',
title VARCHAR(250) NOT NULL DEFAULT '',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
pagetext MEDIUMTEXT,
allowsmilie SMALLINT NOT NULL DEFAULT '0',
showsignature SMALLINT NOT NULL DEFAULT '0',
ipaddress CHAR(15) NOT NULL DEFAULT '',
iconid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
visible SMALLINT NOT NULL DEFAULT '0',
attach SMALLINT UNSIGNED NOT NULL DEFAULT '0',
infraction SMALLINT UNSIGNED NOT NULL DEFAULT '0',
reportthreadid INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (postid),
KEY userid (userid),
KEY threadid (threadid, userid),
FULLTEXT KEY title (title, pagetext)
) ENGINE=MyISAM;
MySQL Error : You have an error in your SQL syntax near 'ENGINE=MyISAM
' at line 23
Error Number : 1064

[Colin F]

What version of MySQL are you using?
Be advised that the minimum version is 4.0.16

[June]

Hello!

The version is : 3.23.58.

So the error is because of old version of MYSQL?

[Colin F]

Yes.
Ask your host to upgrade to at least 4.0.16, preferrably 4.4.2 or 5.1.2 though.

[Tomek]

Yes.
Ask your host to upgrade to at least 4.0.16, preferrably 4.4.2 or 5.1.2 though.
You mean MySQL 4.1.20 or 5.0.22, I think. ;)

[Floris]

As per announcement: http://www.vbulletin.com/forum/showthread.php?t=186803


System Requirements
vBulletin 3.6 now requires PHP 4.3.3 or later and MySQL 4.0.16 or later. These minimum versions are still several years old, so the vast majority of people should still meet the requirements. Check the main page of your admin control panel if you're not sure what versions of PHP and MySQL are on your server!

[June]

Thank you very much.

I wish my host company quickly changes the version.


I am realy exciting to check the search funtion of Japanese.
Cause I am waiting so long!

Thank you.

[June]

Hello!

I got answer from my host.
They will not upgrade MYSQL.
They say there is no plan to upgrade.

Is there any solution?

[Tomek]

Change hosting provider?

[Colin F]

3.23.58 was released in 2003.
If your host doesn't want to upgrade, I recommend you look for a different host.

[Mike Sullivan]

The current version of MySQL is 5.0. Not only is 3.23 deprecated, the two releases after it--4.0 and 4.1--are deprecated.

Your host is 3 generations behind on MySQL, yet they seem to be reasonably up-to-date with PHP...

[June]

Hello!

It seems that it is better to change the host to use this version.

Anyway I got the answer lilke this from the host.
I used translation soft to translate from Japanese to English.
So some part is very strange, but anyway, let me copy here...
uhhhh

***********************************************

> Could you upgrade MySQL?
Excuse me, it is not possible to make our company receive work here
because making our company prepare it becomes a package of the
distribution standard.
It is great if the correspondence along the customer's demand cannot be
able to be done and to understand humbly I am sorry.
Moreover, abnormality might occur in the movement of the server because
it becomes outside the assumption environment of the SWSoft Co. when the
package of the distribution standard is changed when Plesk is used (The
content published in knowledge base/FAQ of the SWSoft Co. is excluded).
Therefore, please do not change as much as possible.
Moreover, please work to exceed the range of our support when it is
changed after it understands beforehand.

[xYarub]

I'm getting the exact same error. I am running MySQL 4.0.17 on my server so why might I be getting the error?

[June]

I am still wondering whether I should change the server or not.
Of course I want to use new version, however we are running several domeins and many data bases using present host. Moving is not so easy.

I asked a professional here, and he said that
they use a general version in the rental server in Japan,and when it becomes 4.1, most of the rental server company hesitate to upgrade because it needs the password changes.

Just the information from Japan.

[Marco van Herwaarden]

I'm getting the exact same error. I am running MySQL 4.0.17 on my server so why might I be getting the error?
Youmight be better of starting your own thread with all the info you can give. Since you are running a different MySQL version, the problem (and probably solution) is different.

[Marco van Herwaarden]

I asked a professional here, and he said that
they use a general version in the rental server in Japan,and when it becomes 4.1, most of the rental server company hesitate to upgrade because it needs the password changes.

Just the information from Japan.
They are probably referring to the fact that in the later MySQL version by default it is only accepting encrypted passwords. This would break any PHP-script that access MySQL through an older client library.

This problem can easily be avoided by setting a my.cnf setting to also accept old style passwords, or upgrade the client-libraries.