eVRECIA Posted June 25 Share Posted June 25 After writing copy_shopdata.php these errors: 1 accessory 38 Fatal error: Uncaught mysqli_sql_exception: SELECT command denied to user 'db109971xnova'@'10.10.51.16' for table `db109971xbiopla`.`ps_accessory` in /www/b/i/u109971/public_html/admin500bwd3vsijqzrprxtm/Prestools_Suite/copy_shopdata_functions.inc.php:7 Stack trace: #0 /www/b/i/u109971/public_html/admin500bwd3vsijqzrprxtm/Prestools_Suite/copy_shopdata_functions.inc.php(7): mysqli_query(Object(mysqli), 'INSERT INTO `db...') #1 /www/b/i/u109971/public_html/admin500bwd3vsijqzrprxtm/Prestools_Suite/copy_shopdata_functions.inc.php(587): dbxquery(Object(mysqli), 'INSERT INTO `db...') #2 /www/b/i/u109971/public_html/admin500bwd3vsijqzrprxtm/Prestools_Suite/copy_shopdata_functions.inc.php(458): copy_table_direct('accessory', 'ps_', '`id_product_1`,...', Array) #3 /www/b/i/u109971/public_html/admin500bwd3vsijqzrprxtm/Prestools_Suite/copy_shopdata.php(228): copy_table('accessory') #4 {main} thrown in /www/b/i/u109971/public_html/admin500bwd3vsijqzrprxtm/Prestools_Suite/copy_shopdata_functions.inc.php on line 7 Link to comment Share on other sites More sharing options...
Nickz Posted June 25 Share Posted June 25 Denied that should be a permission related error. Link to comment Share on other sites More sharing options...
eVRECIA Posted June 26 Share Posted June 26 I am a beginner in working with databases. What error related to permission? Link to comment Share on other sites More sharing options...
tasPuika Posted June 26 Share Posted June 26 Quote denied to user 'db109971xnova'@'10.10.51.16' for table `db109971xbiopla`.`ps_accessory` as your MySQL root you must grant permissions via something like (this is too wide for real life): grant all on `db109971xbiopla`.* to 'db109971xnova'@'10.10.51.16' Link to comment Share on other sites More sharing options...
eVRECIA Posted June 26 Share Posted June 26 But why only for the table ps_accessory, if in the database are all tables from PS 8.1.6. Link to comment Share on other sites More sharing options...
musicmaster Posted June 26 Author Share Posted June 26 Rights problems usually happen when copying from one mysql installation to another. I don't have a solution for that, except for the suggestion to copy the database to the target installation and use that as the basis for copy_shopdata, Link to comment Share on other sites More sharing options...
gregor5 Posted July 18 Share Posted July 18 (edited) We are about to try upgrading an old 1.6.1.24 Prestashop version using your script. We tried with 1 click upgrade but it doesn't work. Would you recommend we try and do a fresh installation of the same Prestashop version, transfer tables, and try again with 1-click or can we go straight from 1.6 to 8.1 (or 1.7)? Edited July 18 by gregor5 (see edit history) Link to comment Share on other sites More sharing options...
Nickz Posted July 18 Share Posted July 18 2 hours ago, gregor5 said: can we go straight from 1.6 to 8.1 (or 1.7)? You cannot, you need to go step by step thru the entire tree. Why do you wish to update. No themes you like? Do clients complain about the optic? Most shops look alike when opened with a mobile phone. Link to comment Share on other sites More sharing options...
musicmaster Posted July 18 Author Share Posted July 18 4 hours ago, gregor5 said: We are about to try upgrading an old 1.6.1.24 Prestashop version using your script. We tried with 1 click upgrade but it doesn't work. Would you recommend we try and do a fresh installation of the same Prestashop version, transfer tables, and try again with 1-click or can we go straight from 1.6 to 8.1 (or 1.7)? I would suggest a fresh 8.1 installation and then going straight from the old shop to that version. Let me know when you notice any problem. Link to comment Share on other sites More sharing options...
Biscot Posted October 22 Share Posted October 22 Hello, an update for prestashop 8.2?, because when I try I get this "Prestashop 8.2 is not yet supported by Prestools." Link to comment Share on other sites More sharing options...
musicmaster Posted October 22 Author Share Posted October 22 11 minutes ago, Biscot said: Hello, an update for prestashop 8.2?, because when I try I get this "Prestashop 8.2 is not yet supported by Prestools." Download the latest version of Prestools. Link to comment Share on other sites More sharing options...
Biscot Posted October 22 Share Posted October 22 ok it works Link to comment Share on other sites More sharing options...
luismfbsilva061980 Posted November 8 Share Posted November 8 Good morning, I'm trying to use copy_data, but something here is malfunctioning. Presta 8.1.7 on the same server and different folders, different DBs. I just need to transfer the customers, addresses and orders, but I get this error: SELECT command denied to user 'xxxx_xxxxxx'@'localhost' for table `xxxx_xxxxxx1`.`ps_address` MySQL error 1142: SELECT command denied to user 'xxxx_xxxxxx'@'localhost' for table `xxxx_xxxxxx1`.`ps_address` Any suggestions? Link to comment Share on other sites More sharing options...
musicmaster Posted November 8 Author Share Posted November 8 It looks like those databases have different logins and that gives problems. If that is the case you have two options: - you can copy one of the databases or allocate rights so that both can be reached with the same server-user-password combination - you can set the $copy_method variable to row. But that will make the process much slower. Link to comment Share on other sites More sharing options...
luismfbsilva061980 Posted November 8 Share Posted November 8 16 minutes ago, musicmaster said: It looks like those databases have different logins and that gives problems. If that is the case you have two options: - you can copy one of the databases or allocate rights so that both can be reached with the same server-user-password combination - you can set the $copy_method variable to row. But that will make the process much slower. So what it tells me is that I have to put the old database with the same user and pass as the new database, right? Link to comment Share on other sites More sharing options...
musicmaster Posted November 8 Author Share Posted November 8 yes Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now