Quote by: AnonymousHi, Its been about 7 years since I last used geeklog. Back then I went travelling and recorded all my adventures in geeklog. I wanted to get the site back up and running but get the following sql error when trying to import the db using phpmyadmin.
SQL query:
-- MySQL dump 8.22
--
-- Host: localhost Database: theworlcom
------------------------------------------------------- --
-- Server version 3.23.54-log
--
-- Table structure for table 'banned_ips'
--
CREATE TABLE banned_ips(
host_ip VARCHAR( 255 ) DEFAULT NULL
) ENGINE = MYISAM ;
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 '---------------------------------------------------------
-- Server version 3.23' at line 4
I have already changed TYPE=MyISAM to ENGINE=MyISAM, as I was getting myisam errors.
Go easy on me as its been years since I did anything like this, but really really want to get my travel logs back.
Thanks for your time.
Verify that your running the correct MySQL version if you just trying to get the site up and going from an initial state. If you are upgrading at the same time, there again, make sure your running atleast MySQL version 4.0.18 or later. See doc snipit below. As Wayne said, it might be better to just install a fresh copy and then cherry pick the inserts out of the database copy you have.
Text Formatted Code
To install and use Geeklog you will need to have a server running Apache or Microsoft IIS with PHP 5.2.0 or higher installed. You will also need either MySQL 4.0.18 or later (MariaDB 5.1 or later will also work), PostgreSQL 7 or greater (7.4 or later recommended), or Microsoft SQL Server 2000 or newer.