/ps_connections' is marked as crashed and last (automatic?) repair failed

[SB Lite]

Hi

 

Trying to open the list of customers and getting the following error:

 

'/ps_connections' is marked as crashed and last (automatic?) repair failed'

 

Ive gone onto myPHPadmin and tried opening the /ps_connections table and get the error

 

'#144 - Table is marked as crashed and last (Automatic?) repair failed.

 

 

Any advice on resolving this?

 

Thanks

Scott

[shokinro]

if you have a backup, you may consider to restore that table from a earlier backup. otherwise, you may have to consider to drop the table and recreate the table again.

[SB Lite]

Is anyone able to do this for me... If so please send me a message with how much you would charge - Think there are a few tables that need sorting. 

[selectshop.at]

This table is only for statistics purposes. If it crashed, perhaps it is too big and I would not restore. In this case it is better you empty (truncate) this table. You can easily do this with phpmyAdmin.

 

Tutorial (it's for WordPress database, but it doeswn't mater, you can follow): https://codex.wordpress.org/Emptying_a_Database_Table

 

or YT

 

[shokinro]

@SB Lite,

I just sent you a PM, please check your message.

[SB Lite]

So I've managed to get all the others working apart from the connections one that I've managed to delete. Can anyone tell me the headers of the table so I can re-build it?

 

Thanks

Scott

[musicmaster]

Best you can do is to download and install a fresh Prestashop from the same version on your pc and copy its table to the shop. Note that there are small database structure differences between the PS versions.

[shokinro]

you should be able to find the SQL for the table definition in following folder of your version prestashop package

 

 

/install/data/db_structure.sql

 

you will be able to find the tables your want from that file. run the sql on your store database via DB tools such as PhpMyAdmin.

for example, below is one of those tables. You need delete existing table first then run this.

 

Also make sure replace PREFIX_ with correct one that used for your store.

 

CREATE TABLE `PREFIX_connections` (
  `id_connections` int(10) unsigned NOT NULL auto_increment,
  `id_shop_group` INT(11) UNSIGNED NOT NULL DEFAULT '1',
  `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1',
  `id_guest` int(10) unsigned NOT NULL,
  `id_page` int(10) unsigned NOT NULL,
  `ip_address` BIGINT NULL DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `http_referer` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_connections`),
  KEY `id_guest` (`id_guest`),
  KEY `date_add` (`date_add`),
  KEY `id_page` (`id_page`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8 COLLATION;

[SB Lite]

Perfect, thanks for your help.

[SB Lite]

For those who ever have the same issue. I managed to solve the crashing error after the host updated from MySQL to MariaDB

[shokinro]

so it is database engine related problem?

roughly how big size of your connection table?

[994830_1508427849]

I ended up in this topic coz i had the same issue with "connection" table, I applied this below fix which worked like a charm so far. 

I founded this on the following website: https://www.thoughtco.com/repairing-mysql-database-with-phpmyadmin-2693966
 

phpMyAdmin Repair Steps

1 - Log in to your web host.

2 - Click the phpMyAdmin icon. 

3 - Choose the affected database. 

4 - In the main panel, you should see a list of your database tables. Click Check All to select all of them.
     This step i did differently, i only selected "connection" table and it did the trick. 

5 - Choose Repair Table from the drop-down menu at the bottom of the screen.

6- When the page refreshes, you should see a summary of any tables that were repaired.

This should fix your database and let you access it again. Now that it is fixed, it's a good idea to make that database backup.