* user warning: 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 '-isml09-round auu-isml09-round ) count_alias' at line 2 query: SELECT COUNT(*) FROM (SELECT auu-isml09-round.id AS id FROM auu-isml09-round auu-isml09-round ) count_alias in /home2/etherune/public_html/sites/all/modules/views/includes/view.inc on line 729.
* user warning: 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 '-isml09-round_round, auu-isml09-round.date AS auu-isml09-round_date, auu-i' at line 2 query: SELECT auu-isml09-round.id AS id, auu-isml09-round.round AS auu-isml09-round_round, auu-isml09-round.date AS auu-isml09-round_date, auu-isml09-round.opponent AS auu-isml09-round_opponent, auu-isml09-round.score_auu AS auu-isml09-round_score_auu, auu-isml09-round.score_opp AS auu-isml09-round_score_opp, auu-isml09-round.total_vote AS auu-isml09-round_total_vote, auu-isml09-round.diff_vote AS auu-isml09-round_diff_vote, auu-isml09-round.vote_per AS auu-isml09-round_vote_per, auu-isml09-round.result AS auu-isml09-round_result FROM auu-isml09-round auu-isml09-round LIMIT 0, 25 in /home2/etherune/public_html/sites/all/modules/views/includes/view.inc on line 755.
My previous (already left) host doesn't have any problems with displaying an interface of my created database.
The database is a simple one. I'm exporting from Microsoft Access so that I can display its contents in my site. I'm using a module in Drupal (Table Wizard) that displays the contents of a table in a table form. I can display the tables that comes with Drupal but I can't display (and that error shows up) those I created.
I was browsing Drupal and it says something about permission and stuff. All I know is I have an SQL user with all the privilege on my database. I can confirm that I did it right since I was able to install Drupal.
Also, it seems that I can't log out in my phpAdmin. It says: "Wrong username/password. Access denied." I don't know if that can help.
Here's the output I'm trying to work with in my new host : http://etherune.exofire.net/auu/isml/round09
Comments
bump
bump
*BUMP*
*BUMP*
BUMP BUMP
BUMP BUMP
+1
Bumpelibump...
Reserved terms?
I think I solved my import problems by renaming the column heads. I had one called "key" and one called "comment". Renaming them to "xkey" and "xcomment" made the import work like a charm.
I think this is something that mySQL does, not the Table Wizard module. I first tried converting my CSV to an SQL import statement, something like:
When I ran this in phpMyAdmin I got the same error message as Table Wizard threw at me -- and I could also see that the words KEY and COMMENT seemed to be treated differently than the other headers.
I hope this helps.
...and another thing
When importing from CSV, Table Wizard doesn't seem to interpret any columns as primary keys -- which are needed in order to use the table in Views.
Here's how I got Table Wizard to find my column of primary keys:
1. Import the CVS to a table using Table Wizard Import Delimited Files (included in TW).
2. Use phpMyAdmin (or another suitable tool) to edit the imported table (in mySQL form).
3. Change the column containing your primary key to INTEGER with length 10.
4. Once this is done, you can set the column as primary key (which in phpMyAdmin is done by clicking the key icon).
5. Just to be sure, I edited the properties for the column and added the attribute UNSIGNED. Don't know what this means, though. :-)
6. Go back to Table Wizard, find your table, and click *reanalyze* to make TW find the primary key.
Once this is done, you should have a View set up and ready to use!