View Single Post
  #1 (permalink)  
Old September 17th, 2012, 08:58 PM
nanoo_k nanoo_k is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ch.6: Creating a Guestbook

I'm having trouble creating the guestbook component. When I try to install, Joomla throws the error below.

I tried putting the install.sql and uninstall.sql in the root folder, tried putting them in their own folders, tried creating an admin folder (all in attempts to mimic the XML schema). All threw errors (but different errors). Any ideas?

Here is my file structure:

com_guestbook
---.project
---admin.guestbook.php
---guestbook.php
---guestbook.xml
---install.sql
---uninstall.sql

Here is the error Joomla throws:
JInstaller::install: SQL Error. DB function failed with error number 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 ''#__guestbook' ('id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, 'message' tex' at line 1 SQL=CREATE TABLE IF NOT EXISTS '#__guestbook' ('id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, 'message' text NOT NULL, 'created_by' INTEGER UNSIGNED NOT NULL, 'location' VARCHAR(45), 'created' TIMESTAMP NOT NULL, 'userip' VARCHAR(16), PRIMARY KEY('id'))
SQL =
CREATE TABLE IF NOT EXISTS '#__guestbook'
('id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'message' text NOT NULL, 'created_by' INTEGER UNSIGNED NOT NULL,
'location' VARCHAR(45), 'created' TIMESTAMP NOT NULL,
'userip' VARCHAR(16), PRIMARY KEY('id'))
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 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 ''#__guestbook' ('id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, 'message' tex' at line 1 SQL=CREATE TABLE IF NOT EXISTS '#__guestbook' ('id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, 'message' text NOT NULL, 'created_by' INTEGER UNSIGNED NOT NULL, 'location' VARCHAR(45), 'created' TIMESTAMP NOT NULL, 'userip' VARCHAR(16), PRIMARY KEY('id'))
SQL =
CREATE TABLE IF NOT EXISTS '#__guestbook'
('id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'message' text NOT NULL, 'created_by' INTEGER UNSIGNED NOT NULL,
'location' VARCHAR(45), 'created' TIMESTAMP NOT NULL,
'userip' VARCHAR(16), PRIMARY KEY('id'))