Invalid SQL: ALTER TABLE userfield CHANGE field1 field1 MEDIUMTEXT NOT NULL

[Junior]

Or if you can simply turn safe_mode off in your /etc/php.ini file.

[Junior]

Database error in vBulletin 3.0.1:

Invalid SQL: ALTER TABLE userfield CHANGE field1 field1 MEDIUMTEXT NOT NULL
mysql error: BLOB column 'field1' used in key specification without a

...

[Junior]

Steve, I figured it out. I went from 2.2.8 to 2.3.4 and i don;t think the upgrade script on 2.2.9 ran correctly.
Thanks for the prompt response. You guys are the best.

[Junior]

Database error in vBulletin 2.3.4:

Invalid SQL:

INSERT INTO useractivation

(useractivationid, userid, dateline, activationid, type, usergroupid)

VALUES...

[Junior]

I want to have the e-mail option on for my website, but when it sends them the confirmation e-mail, the activiation code doesn't work. Is this a known issue. Please help.

I am running vb...

[Junior]

Database error in vBulletin 2.2.1:

Invalid SQL: DELETE FROM search WHERE dateline<1014064352
mysql error: Incorrect key file for table: 'search'. Try to repair it

...

[Junior]

That would be right. I had that installed a while back. Is there a way I can remove the phpprotals installation easily or is it really a problem?

[Junior]

The only hack I have installed is the "sponsored by" hack. Could this be causing my problem?

[Junior]

I get this error when trying to repair the database...

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: CHECK TABLE P_bblock
mysql error: You have an...

[Junior]

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT attachmentid FROM post WHERE attachmentid IN (0,0) AND threadid<>'20317'
mysql error: Got error 134 from table handler...

[Junior]

like this:...

[Junior]

We have thousands of posts in the "91SICCNESS" Forum. If you look at the posts at the bottom, there should be numbered links, linking to the other older post pages. This is what is not showing...

[Junior]

And guest are now able to see threads.

[Junior]

ok profile updated

[Junior]

Can someone help me figure out why the Old Posts links (the numbers at the bottom of the screen) aren;t showing up after a fresh install of the bulletin board version 2.0.3?

http://www...