| Author |
Message |
aurelia
Joined: 27 May 2013
Posts: 5
Location: Lieskau, Germany
|
 Posted: Mon May 27, 2013 7:22 am |
 
|
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
|
|
|
 |
|
aurelia
Joined: 27 May 2013
Posts: 5
Location: Lieskau, Germany
|
|
Posted: Mon May 27, 2013 9:47 am |
|
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.
|
|
|
|
|
aurelia
Joined: 27 May 2013
Posts: 5
Location: Lieskau, Germany
|
|
Posted: Tue May 28, 2013 4:08 am |
|
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]
|
|
|
|
|
Tech Support
Joined: 27 Aug 2004
Posts: 2688
|
|
Posted: Wed May 29, 2013 8:09 am |
|
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
|
|
|
|
aurelia
Joined: 27 May 2013
Posts: 5
Location: Lieskau, Germany
|
|
Posted: Wed May 29, 2013 1:08 pm |
|
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.
|
|
|
|
|
|
|
|
