FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 Problems creating the two database tables that are needed... View next topic
View previous topic
Post new topicReply to topic
Author Message
aurelia



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

PostPosted: Mon May 27, 2013 7:22 am Reply with quoteBack to top

Hi,

I followed the RSS2SQL v3.x Instructions to install the script and to create the database on my domain hosted by fatcow.com:

1. unzipped the rss2sql.zip file and copied the contents by FTP to the web server;

2. ran the install module (rss2sql_install.php) and submitted;
3.created and uploaded the new configuration file as "rss2sql_DBconfig.inc.php";

4. ran .../rss2sql.php?buildConfig and saw the lot of fields, followed the advice not to touch them... and clicked on "Generate Data";

5. then saved the new configuration file contents ...
-> was it correct to name this new file again "rss2sql_DBconfig.inc.php" and therefore to overwrite the previous one that had been created under point 3?

on the same page there was also the code to create the two database tables that are needed by rss2sql, with the hint to copy it into the command-line for my database...
Here I got stuck. How do I get into the commandline for my database? Or where else could I paste the code for the tables, or how else could I create those two tables?

Appreciate your help.

Best regards,
Aurelia
View user's profile
aurelia



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

PostPosted: Mon May 27, 2013 9:47 am Reply with quoteBack to top

Hi all,

I tried to create SQL Database via Contol Panel on fatcow.com and imported then the script for creating the two tables.

Here is the reaction output that I got:

===BEGINNING

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 1605
STR: '
SQL:

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;


SQL query:

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;

MySQL said: Documentation
#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

==== END

So my question is: Is there really a syntax error in the code above? And what language is the code above, is it SQL.
View user's profile
aurelia



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

PostPosted: Tue May 28, 2013 4:08 am Reply with quoteBack to top

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



Joined: 27 Aug 2004
Posts: 2782

PostPosted: Wed May 29, 2013 8:09 am Reply with quoteBack to top

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.

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



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

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

Thanks for your kind reply.

Indeed, this solved the issue.
After correcting the SQL code file for creating Table 'feedItems' manually,
things worked smoothly.

@ Gamliel: Maybe this is also the solution for the problem that you posted. It looked to me similiar to my issue.
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