Skip to Content Skip to Menu

error 1064

  • civoc
  • civoc
  • OFFLINE
  • Posts: 3
  • Thanks: 0
  • Karma: 0
15 years 9 months ago #87458 by civoc
error 1064 was created by civoc
after trying to alter mysql tables i get
QL query:

ALTER TABLE `jos_uddeim_userlists` ADD `global` INT( 1 ) NOT NULL DEFAULT '0' ALTER TABLE `jos_uddeim_userlists` ADD INDEX ( `global` )

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 'ALTER TABLE `jos_uddeim_userlists` ADD INDEX ( `global` )' at line 2

I'm using MySQL version 5.0.67-community

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
15 years 9 months ago #87459 by slabbi
Replied by slabbi on topic Re:error 1064
These are two lines, not one ;)

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

  • civoc
  • civoc
  • OFFLINE
  • Posts: 3
  • Thanks: 0
  • Karma: 0
15 years 9 months ago #87461 by civoc
Replied by civoc on topic Re:error 1064
slabbi wrote:

These are two lines, not one ;)

It's ignoring the second line though

Please Log in or Create an account to join the conversation.

  • civoc
  • civoc
  • OFFLINE
  • Posts: 3
  • Thanks: 0
  • Karma: 0
15 years 9 months ago #87465 by civoc
Replied by civoc on topic Re:error 1064
figured out the culprit

u can't change or alter mysql using google chrome, when I changed to ff it worked.

Please Log in or Create an account to join the conversation.

Moderators: beatnantslabbikrileon
Powered by Kunena Forum