| Author |
Message |
gamliel
Joined: 22 Mar 2013
Posts: 3
Location: paris
|
 Posted: Fri Mar 22, 2013 5:31 am |
 
|
Hi everyone,
I'm getting this adress when I try to create the database.
#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 '\',$_POST[\'ItemDCDescription\']; ?> VARCHAR(255) NOT NULL DEFAULT "", ItemDC' at line 33
the "feed info" table is created but not the "feedItems"
thanks for helping.
Gamliel
|
|
|
 |
|
Tech Support
Joined: 27 Aug 2004
Posts: 2692
|
|
Posted: Mon Mar 25, 2013 10:57 am |
|
|
|
|
gamliel
Joined: 22 Mar 2013
Posts: 3
Location: paris
|
|
Posted: Thu Mar 28, 2013 6:20 am |
|
CREATE TABLE feedInfo (
feedID INT AUTO_INCREMENT,
feedActive TINYINT NOT NULL DEFAULT '1',
feedURL VARCHAR(250) NOT NULL DEFAULT '',
updateInterval INT NOT NULL default '86400',
lastUpdate DATETIME NOT NULL default '0000-00-00 00:00:00',
nextUpdate DATETIME NOT NULL default '0000-00-00 00:00:00',
updateStatus VARCHAR(32) NOT NULL default '',
updateStatusCount TINYINT NOT NULL default '0',
PRIMARY KEY(feedID)
) CHARSET=utf8;
CREATE TABLE feedItems (
itemID INT AUTO_INCREMENT,
feedID INT NOT NULL DEFAULT '0',
CreatedUniqueID VARCHAR(250) NOT NULL DEFAULT '',
ItemAddedTime DATETIME NOT NULL default '0000-00-00 00:00:00',
ItemTitle TEXT NOT NULL DEFAULT '',
ItemDescription MEDIUMTEXT NOT NULL DEFAULT '',
ItemContentEncoded MEDIUMTEXT NOT NULL DEFAULT '',
ItemLink VARCHAR(250) NOT NULL DEFAULT '',
ItemPubDate VARCHAR(250) NOT NULL DEFAULT '',
ItemPubDate_t DATETIME NOT NULL default '0000-00-00 00:00:00',
ItemEnclosureUrl VARCHAR(250) NOT NULL DEFAULT '',
ItemEnclosureType VARCHAR(250) NOT NULL DEFAULT '',
ItemEnclosureLength VARCHAR(250) NOT NULL DEFAULT '',
ItemGuid VARCHAR(250) NOT NULL DEFAULT '',
ItemAuthor VARCHAR(250) NOT NULL DEFAULT '',
ItemComments VARCHAR(250) NOT NULL DEFAULT '',
ItemSource VARCHAR(250) NOT NULL DEFAULT '',
ItemSourceUrl VARCHAR(250) NOT NULL DEFAULT '',
ItemCategory VARCHAR(250) NOT NULL DEFAULT '',
ItemCategoryDomain VARCHAR(250) NOT NULL DEFAULT '',
ItemCreativeCommons VARCHAR(250) NOT NULL DEFAULT '',
ItemITunesSubtitle VARCHAR(255) NOT NULL DEFAULT "",
ItemITunesSummary MEDIUMTEXT NOT NULL DEFAULT "",
ItemITunesDuration VARCHAR(255) NOT NULL DEFAULT "",
ItemITunesKeywords VARCHAR(255) NOT NULL DEFAULT "",
ItemITunesAuthor VARCHAR(255) NOT NULL DEFAULT "",
ItemITunesExplicit VARCHAR(255) NOT NULL DEFAULT "",
ItemITunesBlocked VARCHAR(255) NOT NULL DEFAULT "",
ItemTrackBackPing VARCHAR(255) NOT NULL DEFAULT "",
ItemTrackBackAbout MEDIUMTEXT NOT NULL DEFAULT "",
ItemDCTitle VARCHAR(255) NOT NULL DEFAULT "",
',$_POST['ItemDCDescription']; ?> VARCHAR(255) NOT NULL DEFAULT "",
ItemDCDate VARCHAR(255) NOT NULL DEFAULT "",
ItemDCSubject VARCHAR(255) NOT NULL DEFAULT "",
ItemDCCreator VARCHAR(255) NOT NULL DEFAULT "",
ItemDCPublisher VARCHAR(255) NOT NULL DEFAULT "",
ItemDCContributor VARCHAR(255) NOT NULL DEFAULT "",
ItemDCLanguage VARCHAR(255) NOT NULL DEFAULT "",
ItemDCRights VARCHAR(255) NOT NULL DEFAULT "",
ItemDCType VARCHAR(255) NOT NULL DEFAULT "",
ItemDCFormat VARCHAR(255) NOT NULL DEFAULT "",
ItemDCIdentifier VARCHAR(255) NOT NULL DEFAULT "",
ItemDCSource VARCHAR(255) NOT NULL DEFAULT "",
ItemDCRelation VARCHAR(255) NOT NULL DEFAULT "",
ItemDCCoverage VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSArtist VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSArtistLink MEDIUMTEXT NOT NULL DEFAULT "",
ItemITMSAlbum VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSAlbumLink MEDIUMTEXT NOT NULL DEFAULT "",
ItemITMSAlbumPrice VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSCoverArt53 VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSCoverArt60 VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSCoverArt100 VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSFeatureArt VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSSong VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSSongLink MEDIUMTEXT NOT NULL DEFAULT "",
ItemITMSRank VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSRights VARCHAR(255) NOT NULL DEFAULT "",
ItemITMSReleaseDate VARCHAR(255) NOT NULL DEFAULT "",
PRIMARY KEY(itemID),
INDEX (CreatedUniqueID)
) CHARSET=utf8;
|
|
|
|
|
gamliel
Joined: 22 Mar 2013
Posts: 3
Location: paris
|
|
Posted: Sun Apr 07, 2013 4:30 pm |
|
|
|
|
aurelia
Joined: 27 May 2013
Posts: 5
Location: Lieskau, Germany
|
|
Posted: Wed May 29, 2013 1:19 pm |
|
Hello Gamliel,
I noticed that you were writing about the same problem which I had with the SQL code to create the database table 'feedItems'.
Just wanted to forward the info to you that helped me solve the problem.
There was indeed an error in the SQL code.
Please find the info quoted below. Hope this works for you, too.
[quote="aurelia"]Hello all,
I once more went through the setup procedure, trying to figure out possible mistakes that I might have committed.
This time, I first created a new MySQL database on my www.fatcow.com server, and used its settings (db name, location,login, password) when running rss2sql_install.php.
Saved the new configuration file as "rss2sql_DBconfig.inc.php" and uploaded it to my server, where the other rss2sql files are.
Ran ~ rss2sql.php?buildConfig, hit "Generate configuration data", copied the data into a new file and saved it as "rss2sql_config.php"
-> Question: is this the correct filename, or should this config file be saved with a different filename?
Also copied the code for creation of the two database tables...
Assumed that this code is in SQL format...??
And named the two files as follows:
1. _create_table_feedInfo.sql
2. _create_table_feedItems.sql
Imported the first table into mysqladmin.fatcow... and it was created properly.
Imported the second table into mysqladmin.fatcow... and got again THIS ERROR MESSAGE about SQL Syntax Error:
"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 '\',$_POST[\'ItemDCDescription\']; ?> VARCHAR(255) NOT NULL DEFAULT "",
ItemDCD' at line 33 "
Indeed, line 33 looks different from all others:
...
ItemTrackBackPing VARCHAR(255) NOT NULL DEFAULT "",
ItemTrackBackAbout MEDIUMTEXT NOT NULL DEFAULT "",
ItemDCTitle VARCHAR(255) NOT NULL DEFAULT "",
\',$_POST[\'ItemDCDescription\']; ?> VARCHAR(255) NOT NULL DEFAULT "",
ItemDCDate VARCHAR(255) NOT NULL DEFAULT "",
ItemDCSubject VARCHAR(255) NOT NULL DEFAULT "",
ItemDCCreator VARCHAR(255) NOT NULL DEFAULT "",
...
is this \',$_POST expression correct at this place? Or should I just delete it
I would really appreciate any help very much, as I need to get on with this.
[/b][/quote]
[quote="Tech Support"]Yes, the SQL code should look more like this:
...
ItemTrackBackPing VARCHAR(255) NOT NULL DEFAULT "",
ItemTrackBackAbout MEDIUMTEXT NOT NULL DEFAULT "",
ItemDCTitle VARCHAR(255) NOT NULL DEFAULT "",
ItemDCDescription VARCHAR(255) NOT NULL DEFAULT "",
ItemDCDate VARCHAR(255) NOT NULL DEFAULT "",
ItemDCSubject VARCHAR(255) NOT NULL DEFAULT "",
ItemDCCreator VARCHAR(255) NOT NULL DEFAULT "",
...
Try changing that file manually and using it again to create the SQL table.[/quote]
|
|
|
|
|
|
|
|
