FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 Problem when creating the database View next topic
View previous topic
Post new topicReply to topic
Author Message
gamliel



Joined: 22 Mar 2013
Posts: 3
Location: paris

PostPosted: Fri Mar 22, 2013 5:31 am Reply with quoteBack to top

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
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2783

PostPosted: Mon Mar 25, 2013 10:57 am Reply with quoteBack to top

I can't seem to find that text in the RSS2SQL files.

Can you post the exact text you are using to create the database(s)?

Thanks

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
gamliel



Joined: 22 Mar 2013
Posts: 3
Location: paris

PostPosted: Thu Mar 28, 2013 6:20 am Reply with quoteBack to top

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;
View user's profile
gamliel



Joined: 22 Mar 2013
Posts: 3
Location: paris

PostPosted: Sun Apr 07, 2013 4:30 pm Reply with quoteBack to top

HELP?
View user's profile
aurelia



Joined: 27 May 2013
Posts: 5
Location: Lieskau, Germany

PostPosted: Wed May 29, 2013 1:19 pm Reply with quoteBack to top

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]
View user's profile
Display posts from previous:      
Post new topicReply to topic


 Jump to:   



View next topic
View previous topic


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme