FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


SQL import error





yo.hassan
i made my wordpress site on my localhost with xampp. everything works just great but now when i wanted to pulish it, import the sql tables, it says this...

Quote:

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 02, 2007 at 11:26 AM
-- Server version: 5.0.41
-- PHP Version: 4.4.7
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL said: Documentation
#1193 - Unknown system variable 'SQL_MODE'

i tried both php 4 and php version but always the same error. what can do now? your suggestion is highly needed. please... thanks[/quote]
mathiaus
you have mysql 5 on your PC, Frihost uses v4. Just remove the problem line "SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; "
yo.hassan
mathiaus wrote:
you have mysql 5 on your PC, Frihost uses v4. Just remove the problem line "SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; "
thanks mathius. i guess my php version is 4 but the mysql version is 5 and its causing all the trouble, na? deleting the highlighted line would solve it? i'd try and let you know(when i get some time out my office) thanks again for the hint and reply.
Related topics
Sql/Phpbb error...
Strange SQL error
php sql import
Save the Best Smileys Website
Paid hosting
Servlets
Is this code safe, or not?
Getting Fatal Error in php mysqli
Help: SQL error after uploading new files(thread updated)
Sql Error: 1017. Missing all the indexes files of phpbb
MYSQL import problems
SQL error notification in my forum
Error on running a Big SQL Statement on MySql
SQL error
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.