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: Uploading Database and Got this Error::  (Read 2834 times)

0 Members and 1 Guest are viewing this topic.

PvtPulse

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 77
Uploading Database and Got this Error::
« on: August 20, 2006, 02:02:50 pm »

www.3lwavenue.com/gallery

Quote
Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 20, 2006 at 04:59 AM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `lwavenue_gallery`
--
-- --------------------------------------------------------
--
-- Table structure for table `agb_book_auth`
--
CREATE TABLE `agb_book_auth` (

`ID` smallint( 5 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 60 ) NOT NULL default '',
`password` varchar( 60 ) NOT NULL default '',
`session` varchar( 32 ) NOT NULL default '',
`last_visit` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM AUTO_INCREMENT =2DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;



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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 8

« Last Edit: August 20, 2006, 03:36:26 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: Uploading Database and Got this Error::
« Reply #1 on: August 20, 2006, 02:23:59 pm »

You are transferring to an older version of mysql so you need to use the compatibility options when you make the dump.
Logged

PvtPulse

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 77
Re: Uploading Database and Got this Error::
« Reply #2 on: August 20, 2006, 03:26:08 pm »

Why am I still getting this error message now that I have transferred the database:

www.3lwavenue.com/gallery
« Last Edit: August 20, 2006, 03:49:44 pm by PvtPulse »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Uploading Database and Got this Error::
« Reply #3 on: August 20, 2006, 09:58:12 pm »

Don't edit out your postings! The page is in maintenance mode, we can't see any errors, so you should copy the error message and paste it into your reply.
You have another thread running (with a silly subject line btw) that appears to dealing with the same issue: YET ANOTHER PROBLEM, so I'm locking this one. In the future, respect board rules!
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.