Mysql SYNTAX error

[alex clone]

Hey,

I'm trying to install a script and when I press the "Install button" after filling out the info I get this error:

 

Database successfully connected to!
Saving configuration to code-bin/main/config.php...
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 ')' at line 10

 

Anyone know what could cause this error?

[Ken2k7]

Your SQL caused it.

[alex clone]

Do you know how to fix this so it works?

[Ken2k7]

I don't know. Either case, you'll have to post your SQL if you wish to get help on it.

[alex clone]

MySQL version 5.0.67-community

 

SQL

-- phpMyAdmin SQL Dump
-- version 2.11.9.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 12, 2009 at 02:07 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `treznax1_beta`
--

-- --------------------------------------------------------

--
-- Table structure for table `blackmarks`
--

CREATE TABLE IF NOT EXISTS `blackmarks` (
  `caseid` text,
  `userid` text,
  `postid` text,
  `offence` text,
  `comment` text,
  `reason` text,
  `reporter` text,
  `blackmarks` text,
  `year` text,
  `month` text,
  `date` text,
  `hour` text,
  `minute` text,
  `second` text,
  `appealed` text,
  `aYear` text,
  `aMonth` text,
  `aDate` text,
  `aHour` text,
  `aMinute` text,
  `aSecond` text,
  `status` text,
  `aMessage` text,
  `aResponse` text,
  `aResponder` text,
  `final` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blackmarks`
--


-- --------------------------------------------------------

--
-- Table structure for table `catagories`
--

CREATE TABLE IF NOT EXISTS `catagories` (
  `title` text,
  `listed` text,
  `id` text,
  `status` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `catagories`
--


-- --------------------------------------------------------

--
-- Table structure for table `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `title` text,
  `host` text,
  `windowTitle` text,
  `footer` text,
  `categories` text,
  `forums` text,
  `threads` text,
  `posts` text,
  `users` text,
  `cases` text,
  `censor` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`title`, `host`, `windowTitle`, `footer`, `categories`, `forums`, `threads`, `posts`, `users`, `cases`, `censor`) VALUES
('Treznax', 'http://treznax.net/beta/', 'Treznax - Taking You To The Limit!', 'Copyright © Treznax | RuneScape Fan Site | This website and its contents are provided by Jagex Ltd. All content are used for fan use.<br>Use of this website is subject to our <a href="http://Treznax.net/index.php">Terms+Conditions</a>.', '0', '0', '0', '0', '0', '0', '0');

-- --------------------------------------------------------

--
-- Table structure for table `forums`
--

CREATE TABLE IF NOT EXISTS `forums` (
  `title` text,
  `descd` text,
  `listed` text,
  `id` text,
  `forumcat` text,
  `status` text,
  `rules` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forums`
--


-- --------------------------------------------------------

--
-- Table structure for table `posts`
--

CREATE TABLE IF NOT EXISTS `posts` (
  `id` text,
  `creator` text,
  `thread` text,
  `content` text,
  `status` text,
  `createdHour` text,
  `createdMinute` text,
  `createdSecond` text,
  `createdYear` text,
  `createdMonth` text,
  `createdDate` text,
  `hour` text,
  `minute` text,
  `second` text,
  `year` text,
  `month` text,
  `date` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `posts`
--


-- --------------------------------------------------------

--
-- Table structure for table `threads`
--

CREATE TABLE IF NOT EXISTS `threads` (
  `title` text,
  `forum` text,
  `id` text,
  `owner` text,
  `updater` text,
  `status` text,
  `priority` text,
  `year` text,
  `month` text,
  `date` text,
  `hour` text,
  `minute` text,
  `second` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `threads`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `username` text,
  `password` text,
  `rights` text,
  `id` text,
  `secretquestion` text,
  `secretanswer` text,
  `signature` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

[Ken2k7]

*Ken2k7 shudders

 

EWWW, all your fields are text with no PRIMARY KEYs or anything?

[alex clone]

I'm new 2 this and if u mean like there is no crap inside each table? I removed it beofre posting it

 

And yea

[fenway]

I'm new 2 this and if u mean like there is no crap inside each table? I removed it beofre posting it

 

And yea

Perhaps you should read though the stickies  first....