Can
you confirm that you have the proper rights granted in the MySQL user table?
Something like this:
|
Host
| User |
Password | Select_priv |
Insert_priv | Update_priv | Delete_priv | Create_priv |
Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv
| Grant_priv | References_priv | Index_priv |
Alter_priv |
|
localhost | dgc
| 470aee162402249e |
Y |
Y |
Y |
Y |
Y
|
Y |
N |
N |
N |
Y |
N |
N
| Y |
Y |
Good
luck,
Cameron
I'm new to Interchange but I've found the install
and configuration to be very reasonable. I have encountered only one
problem that I can't seem to get past. When I create a new catalog and
configure it to use MySQL, I'm receiving error while trying to create the
database indexes. The tables are all created but I receive the following
error for every table:
table xxxxxxx index failed: Access denied
for user: 'dgc@localhost' to database
'dgc'
I don't understand why I'm getting an access
denied error for the index, but the tables are being created just fine.
Additional Information:
The site is hosted by an ISP and I only have
access to a single MySQL database that is already created. I've provided
the appropriate login/password information to the makecat script and it IS
creating the tables so I know the connection to the database is working.
Even with the index creation error I can access the Interchange store and
perform just about every function. The only thing I've been unable to do
is update the inventory. When I try I get this error 'Sorry, there was
an error in processing this form action. Please report the error or try again
later. (You have an error in your SQL syntax near '= NULL where sku =
'os28113' ' at line 1 )'. I'm not sure if this is related to the index
problem, but that is where I'm starting.
Any help would be greatly
appreciated!
Tom McAlees
tmcalees@rochester.rr.com
|