Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: SQL issues trying to register  (Read 4229 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.02 seconds with 19 queries.