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: SQL issues trying to register  (Read 4022 times)

0 Members and 1 Guest are viewing this topic.

canoeist

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
SQL issues trying to register
« on: January 13, 2006, 09:12:21 pm »

I have run the install routine and entered the mysql information.  But when i try to create the tables I get this message.
mySQL Error: Column count doesn't match value count at row 1on query 'INSERT INTO cpg133_users VALUES (1, 1, 'YES', 'xxxxxxxxxx', 'xxxxxxxxxxxx', NOW(), NOW(), '', '', '', '', '', '', '')'

I have set up the cgi ok and received the mysql details from my ISP.  I have set the chmod settings on the folders as instructed.  can you help please.

P.S for xxxxx read usr name and passwrod. ( I assume)  I changed it for the post.
« Last Edit: January 16, 2006, 07:29:59 pm by TranzNDance »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: SQL issues trying to register
« Reply #1 on: January 14, 2006, 09:01:08 am »

1) judging from the prefix, I guess you're installing the iutdated version cpg1.3.3, so you're on an entirely wrong board
2) are to trying to install into the cgi-bin folder? You mustn't
3) Post a link
Logged

canoeist

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: SQL issues trying to register
« Reply #2 on: January 14, 2006, 02:51:17 pm »

GauGau
I definitly downloaded 1.4.3.  I did wonder when install told me that the default prefix was cpg133.  The only thing taht could be an issue. is that I have copied my album folder from my other web page and that could be 1.3.3. 

http://ccgi.canoeist.plus.com/cpg/install.php  is this the link you want.  Do you need my user name and pasword.

Thanks for the help
Logged

canoeist

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: SQL issues trying to register
« Reply #3 on: January 14, 2006, 02:58:46 pm »

I notice from another post that MYSQL should be local host.  My ISP have given me a name which I entered here.   I will try local host.
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: SQL issues trying to register
« Reply #4 on: January 14, 2006, 04:30:07 pm »

You only use localhost if that's what the webhost says to use and it turns out that's how many do it. But if your webhost provides a name, use it. You can't make up this stuff.
Logged

canoeist

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: SQL issues trying to register
« Reply #5 on: January 16, 2006, 07:25:16 pm »

I have reloaded cpg143 and it all now works thanks.  I did not load my albums this time.

Thanks.

P.S is it possible to use 133 albums in 143?

Cheers

dane
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: SQL issues trying to register
« Reply #6 on: January 16, 2006, 07:29:34 pm »

Yes, you can use 1.3 albums with 1.4.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: SQL issues trying to register
« Reply #7 on: January 16, 2006, 08:16:51 pm »

did you upgrade or did you install a fresh copy? I find this thread very confusing. If you upgraded, you should have done as suggested in the upgrade section of the docs instead of a fresh install.
Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 15 queries.