Guest Posted February 13, 2014 Posted February 13, 2014 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?
Jack_mcs Posted February 13, 2014 Posted February 13, 2014 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
Guest Posted February 13, 2014 Posted February 13, 2014 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
Jack_mcs Posted February 13, 2014 Posted February 13, 2014 I don't know what directadmin is. Your host should be able to tell you though. 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
Guest Posted February 13, 2014 Posted February 13, 2014 I don't know what directadmin is. Your host should be able to tell you though. Direct admin is my control panel ....
Jack_mcs Posted February 13, 2014 Posted February 13, 2014 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
Guest Posted February 13, 2014 Posted February 13, 2014 Ok, found it.. all priviliges are set to 'Yes', but still the same errors....
Jack_mcs Posted February 13, 2014 Posted February 13, 2014 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
Guest Posted February 13, 2014 Posted February 13, 2014 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?
♥14steve14 Posted February 14, 2014 Posted February 14, 2014 What reply did you get from your hosts, assuming that you asked them. REMEMBER BACKUP, BACKUP AND BACKUP
♥joli1811 Posted February 14, 2014 Posted February 14, 2014 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.
Guest Posted February 14, 2014 Posted February 14, 2014 It is a copy of another oscommerce site.. there are some products, modules and a template allready installed
Guest Posted February 15, 2014 Posted February 15, 2014 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?
♥joli1811 Posted February 16, 2014 Posted February 16, 2014 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.
Guest Posted February 16, 2014 Posted February 16, 2014 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?
♥joli1811 Posted February 16, 2014 Posted February 16, 2014 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.
Guest Posted February 17, 2014 Posted February 17, 2014 I got the code (files) and database table. Can i install the site without the install map?
♥joli1811 Posted February 17, 2014 Posted February 17, 2014 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.