Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: MySQL Error syntax -Newbie  (Read 3112 times)

0 Members and 1 Guest are viewing this topic.

Catie

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
MySQL Error syntax -Newbie
« on: July 02, 2007, 08:48:36 am »
Hey!
first of all, is this something that I need to talk to my web host provider about, or you guys? My web host doesn't really have a way of conntact....

Anyway, I'm using "789mb" (http://www.789mb.com) as my host. I kind of stumbled though making a database. then, they had a script installer that included coppermine. (I had used coppermine earlier....kinda. and loved it!) and in the installation, I got this error:


The following errors were encountered and need to be corrected first:

mySQL Error: 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 '*sessions ( session_id varchar(40) NOT NULL default '', user_id int(11) de' at line 1 on query ' CREATE TABLE IF NOT EXISTS *sessions ( session_id varchar(40) NOT NULL default '', user_id int(11) default '0', time int(11) default NULL, remember int(1) default '0', PRIMARY KEY (session_id) ) TYPE=MyISAM COMMENT='Used to store sessions''

do you wonderful ppl have any advice? can u tell from that what I'm doing wrong?

Thanks for ur dedication!
Catie
« Last Edit: July 03, 2007, 08:40:53 am by Sami »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MySQL Error syntax -Newbie
« Reply #1 on: July 02, 2007, 08:53:17 am »
Don't use the auto-installer provided by your webhost. Only supported install method is the one discussed in our docs, using the package we provide.
Logged

Catie

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: MySQL Error syntax -Newbie
« Reply #2 on: July 02, 2007, 08:58:59 am »
wow! what a fast reply! thanks!

and do u suggest a good ftp program because the one I have doesn't allow whole folders to b uploaded, only files
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MySQL Error syntax -Newbie
« Reply #3 on: July 02, 2007, 09:11:34 am »
Logged

Catie

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: MySQL Error syntax -Newbie
« Reply #4 on: July 03, 2007, 07:19:39 am »
 :-[ oooops, should have found that myself!

anway, I got smart FTP and it's working great ('sides a stupid webhost!) now, thanks a ton! ;D :)
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.018 seconds with 15 queries.