Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database problem


Guest

Recommended Posts

PHPmyadmin won't allow me to restore the backup, producing error messages of

 

Error

 

SQL query:

 

-- phpMyAdmin SQL Dump

-- version 2.10.0.2

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Sep 05, 2007 at 01:24 PM

-- Server version: 4.0.27

-- PHP Version: 4.4.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

 

MySQL said: Documentation

#1193 - Unknown system variable 'SQL_MODE'

 

 

& if I remove SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

I then get

 

Error

 

SQL query:

 

--

-- Dumping data for table `products`

--

INSERT INTO `products`

VALUES ( 36, '19', '', 'tmt/meshsm.jpg', 'tmt/meshmed.jpg', '', 'tmt/navymeshsm.jpg', 'tmt/navymeshlg.jpg', 'tmt/redmeshsm.jpg', 'tmt/redmeshlg.jpg', 'tmt/greenmeshsm.jpg', 'tmt/greenmeshlg.jpg', 'tmt/royalbluemeshsm.jpg', 'tmt/royalbluemeshlg.jpg', '', '', '', , '21.2300', '2003-04-24 17:19:37', '2005-02-18 12:45:08', NULL , 350.00, 1, 1, 0, '70' ) ;

 

MySQL said: Documentation

#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 ' '21.2300', '2003-04-24 17:19:37', '2005-02-18 12:45:08', NULL,

 

 

So now I have a very dead live store with no product listings :'(

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...