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
Help: SQL error after uploading new files(thread updated)
Save the Best Smileys Website
Paid hosting
Sql Error: 1017. Missing all the indexes files of phpbb
MYSQL import problems
SQL error notification in my forum
Servlets
Sql/Phpbb error...
Error on running a Big SQL Statement on MySql
SQL error
Is this code safe, or not?
Strange SQL error
Getting Fatal Error in php mysqli
php sql import
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.