Installation SQL issue
Posted: 19 July 2006 01:51 AM   [ Ignore ]
Newbie
Rank
Total Posts:  5
Joined  2006-07-19

When tying the fields in the module area, got this error:

MySQL ERROR:

Error Number: 1064

Description
: 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 ' , ), (7, 11, , ), (9, , , )' at line 1

Query
: INSERT INTO exp_eez_am_map (group_id, asin_f_id, image_f_id, link_f_id) VALUES (1, , , ), (7, 11, , ), (9, , , )

Attached is an image of the options I was trying to set.

Profile
 
 
Posted: 19 July 2006 02:44 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
Rank
Total Posts:  5
Joined  2006-02-16

I’ll try a quick reinstall using the files available in the download- see if I can replicate it.  That section was a bit of a bear.

Profile
 
 
Posted: 19 July 2006 02:59 AM   [ Ignore ]   [ # 2 ]
Administrator
Avatar
Rank
Total Posts:  5
Joined  2006-02-16

OK- I replicated the issue and the following file fixed it on my install.  Just unzip it and replace the mcp.eez_amazon.php file that’s in your system/modules/eez_amazon/ folder.  Think it will do the trick.

I’ll get it replaced in the download package asap.  Thanks for the catch- you’ll no doubt be making a lot of them.  It’s still rough!

File Attachments
mcp.eez_amazon.zip  (File Size: 5KB - Downloads: 8)
Profile
 
 
Posted: 19 July 2006 12:34 PM   [ Ignore ]   [ # 3 ]
Newbie
Rank
Total Posts:  5
Joined  2006-07-19

Glad to help.  Part of the whole beta testing process, no?

Profile
 
 
Posted: 19 July 2006 12:37 PM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  5
Joined  2006-07-19

It took this time.

Can I offer a quick suggestion?  After I updated the “field-mappings”, there was nothing to confirm that I’d updated the setting successfully.

Profile