Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error on index and admin


Guest

Recommended Posts

Posted

After installing i got these errors on homepage:

 

1142 - SELECT command denied to user 'deb48083n4_r'@'localhost' for table 'cars_manufacturers'

 

SELECT * FROM deb48083_source.cars_manufacturers ORDER BY cars_manufacturers_name

 

 

 

and admin:

 

1142 - SELECT command denied to user 'deb48083n4_r'@'localhost' for table 'languages'

 

select languages_id, name, code, image, directory from deb48083_source.languages order by sort_order

 

What to do to get it all working?

Posted

When the database is created, you have to grant privileges to it for it to work correctly. It sounds like you didn't do that. The easiest way to fix this, if you have a helpful host, is to ask them to look at it. If not, you can edit those settings in your control panel.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Posted

When the database is created, you have to grant privileges to it for it to work correctly. It sounds like you didn't do that. The easiest way to fix this, if you have a helpful host, is to ask them to look at it. If not, you can edit those settings in your control panel.

 

Where in directadmin can i do this? any idea?

 

Thanks for the fast reply btw

Posted

I don't know what directadmin is. Your host should be able to tell you though.

 

Direct admin is my control panel ....

Posted

I've never heard of it so I can't help. The ones I am familiar with have a MySQL section where the permissions can be altered. If your host isn't available to help, try going through these posts.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Posted

Ok, found it.. all priviliges are set to 'Yes', but still the same errors....

Posted

Assuming your shop is installed correctly, I would think it is still a problem with permissions. I suggest that you ask the question in the support area for that control panel. Unless someone here is familiar with it, I doubt that you will get much help.

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Posted

I installed the shop correctly.. got the confirmation at the install page, that all was set up good.. also good connection with mysql

 

maybe some other reason we are not thinking off?

Posted

Hi KDB,

 

Just wondering table 'cars_manufacturers'

 

is not part of a standard oscommerce install where did that come from?

 

Regards

Joli

To improve is to change; to be perfect is to change often.

 

Posted

It is a copy of another oscommerce site.. there are some products, modules and a template allready installed

Posted

Ok, so this webshop is for a client of me.

 

It is a copy of another webshop of him, that needs to be moved to a new domain.

There was an install map in it, so i used that, but apparantly something went wrong with the mysqsl db.

 

I have the mysql file of the original webshop.

 

How can i set this up so everything works?

Posted

Sounds to me you are using a new 2.3 install and an old database maybe from an earlier version or something is mixed up there??

 

They would need to be synced .

Regards

Joli

To improve is to change; to be perfect is to change often.

 

Posted

The webshop itself and mysql belong to the same version, it's the same site.

 

But the files had an install map with it, so i used that..

 

Can i install the site without the install map?

Posted

A normal oscommerce does not have an install map in the sense you are talking is this an Sql file??.

 

I can only guess this is the instructions left by the previous developer detailing the changes he made to the database and the files ??

 

An oscommerce store has an SQl and it has the Files these have probably been modified by the previous developer

 

An install map to the best of my knowledge will only detail the changes that have been made to the site by the previous developer

 

That the store has been customized is obvious from your previous posts so the file changes have to be reflected in the database

 

table 'cars_manufacturers'

 

seems you are missing either the code or the database table .

 

regards

Joli

 

PS: maybe missing the point here

To improve is to change; to be perfect is to change often.

 

Posted

I got the code (files) and database table.

 

Can i install the site without the install map?

Posted

You can not install an install map

 

You can upload the site and create a database and install the sql

To improve is to change; to be perfect is to change often.

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...