database is full

[morad kablaoui]

Good morning,

I have just noticed that my "ns_guest" table has become huge, which makes it impossible for me to add any products or pictures. By searching the forum, most of the contributors say that this table is used for statistics and we can empty it without any problem. Is there a correct way to empty it without affecting the site?

Thanks in advance.

[ComGrafPL]

You can test modules like

• https://www.sunnytoo.com/product/prestashop-database-cleaner-module
• https://www.rolige.com/en/prestashop-modules/free/prestashop-database-cleaner-extra-32.html

[Nickz]

Who are you hosting with?

And what are your specs, how much memory do you have, how much is allocated for services?

[ps8modules]

  On 12/20/2023 at 3:08 PM, morad kablaoui said:

Good morning,

I have just noticed that my "ns_guest" table has become huge, which makes it impossible for me to add any products or pictures. By searching the forum, most of the contributors say that this table is used for statistics and we can empty it without any problem. Is there a correct way to empty it without affecting the site?

Thanks in advance.

Expand  

Hi. You can run a few commands in the database and you're done. Information about the Prestashop version and the table prefix is missing here. Then I can give you the commands to run in phpMyAdmin.

[morad kablaoui]

  On 12/20/2023 at 4:00 PM, Nickz said:

Who are you hosting with?

And what are your specs, how much memory do you have, how much is allocated for services?

Expand  

i have prestashop 1.7.3.3

 

[Daresh]

Check out the Tidy module. You can set it up to clean old data from various tables as a CRON task. Your store will keep itself clean automatically.

[morad kablaoui]

i have old version of prestashop 1.7.3.3 and ican't install any module

 

[Daresh]

PrestaShop version should have nothing to do with being able or not to install a module. What happens when you try to install anything?

[morad kablaoui]

  On 12/21/2023 at 4:00 PM, Daresh said:

PrestaShop version should have nothing to do with being able or not to install a module. What happens when you try to install anything?

Expand  

he told me I couldn't do that, and now I can't open my dashboard i try to log in with all accounts and not logging in he told me that "The Employee does not exist, or the password provided is incorrect."

Edited December 21, 2023 by morad kablaoui (see edit history)

[ps8modules]

  On 12/21/2023 at 4:00 PM, Daresh said:

PrestaShop version should have nothing to do with being able or not to install a module. What happens when you try to install anything?

Expand  

Note that it has a full database and therefore cannot write anything from the module's configuration. You advise complete nonsense and you are responsible for the damage, since you recommended it. If the interviewer answered me, he might have problems.

[ps8modules]

  On 12/21/2023 at 4:05 PM, morad kablaoui said:

he told me I couldn't do that, and now I can't open my dashboard i try to log in with all accounts and not logging in he told me that "The Employee does not exist, or the password provided is incorrect."

Expand  

You've gotten to the point where you're going to have to pay a developer to help you fix everything.

[Daresh]

Indeed, if the database is full you may have some issues logging in.

What you can try, is to clear the search index manually. It is also often a lot of data. It can be rebuilt manually after you gain some additional space. It's _search_index and _search_word tables.

[morad kablaoui]

  On 12/21/2023 at 7:41 PM, Daresh said:

Indeed, if the database is full you may have some issues logging in.

What you can try, is to clear the search index manually. It is also often a lot of data. It can be rebuilt manually after you gain some additional space. It's _search_index and _search_word tables.

Expand  

When I search in phpmyadmin, I find a table called "ns_guest" it is very large, can I drop it ?

[Daresh]

If anything, truncate don't drop. Cleaning this table may casue a little issues, like not loading carts to customers who log in to their accounts etc.

[ps8modules]

TRUNCATE TABLE `ns_guest`;

/* delete CONNECTIONS records younger than 2023-01-01 */
DELETE FROM `ns_connections` WHERE `date_add` < '2023-01-01 00:00:00';
DELETE FROM `ns_connections_page` WHERE `time_start` < '2023-01-01 00:00:00';
DELETE FROM `ns_connections_source` WHERE `date_add` < '2023-01-01 00:00:00';

/* delete LOG records younger than 2023-01-01 */
DELETE FROM `ns_log` WHERE `date_add` < '2023-01-01 00:00:00';

/* delete PAGE NOT FOUND records younger than 2023-01-01*/
DELETE FROM `ns_pagenotfound` WHERE `date_add` < '2023-01-01 00:00:00';

 

Edited December 22, 2023 by ps8moduly.cz (see edit history)

[morad kablaoui]

  On 12/22/2023 at 9:29 AM, Daresh said:

If anything, truncate don't drop. Cleaning this table may casue a little issues, like not loading carts to customers who log in to their accounts etc.

Expand  

so what can i do ?

 

[morad kablaoui]

  On 12/22/2023 at 9:30 AM, ps8moduly.cz said:

TRUNCATE TABLE `ns_guest`;
/* delete records younger than 2023-01-01 */
DELETE FROM `ns_connections` WHERE `date_add` < '2023-01-01 00:00:00';
DELETE FROM `ns_connections_page` WHERE `time_start` < '2023-01-01 00:00:00';
DELETE FROM `ns_connections_source` WHERE `date_add` < '2023-01-01 00:00:00';

 

Expand  

when I well use this?

 

[ps8modules]

You do not have to worry. Copy, paste into your phpMyAdmin SQL and execute the command.

[morad kablaoui]

  On 12/22/2023 at 9:46 AM, ps8moduly.cz said:

You do not have to worry. Copy, paste into your phpMyAdmin SQL and execute the command.

Expand  

This will not delete anything necessary, given that the site has been operating for more than ten years

[ps8modules]

And you need to know who joined your e-shop ten years ago and what pages they visited?

Do you want to have a partially optimized database?
Do you need to write to the database?
Older records need to be deleted!

The commands I gave you here are also included in various modules for cleaning the database.

You can, of course, adjust the date in SQL.

Edited December 22, 2023 by ps8moduly.cz (see edit history)

[morad kablaoui]

  On 12/22/2023 at 9:50 AM, ps8moduly.cz said:

And you need to know who joined your e-shop ten years ago and what pages they visited?

Expand  

no hahaha tell me i can change in this SQL code to delet just older users

[Daresh]

That's why I recommend deleting only old data, not all data. Some users complain that after clearing the guest table totally, the carts are not loaded. Loading carts may depend on the guest table (depending on PrestaShop version, I don't remember it now exactly).

I would modify the above queries this way:

DELETE FROM `ns_connections` WHERE `date_add` < '2023-01-01 00:00:00';
DELETE FROM `ns_connections_page` WHERE `time_start` < '2023-01-01 00:00:00';
DELETE FROM `ns_connections_source` WHERE `date_add` < '2023-01-01 00:00:00';
DELETE FROM `ns_guest` WHERE `id_guest` NOT IN (SELECT `id_guest` FROM `ns_connections`) AND `id_customer` = 0

 

[ps8modules]

You can edit your SQL and delete only guests.

DELETE FROM `ns_guest` WHERE id_customer = '0';

 

[morad kablaoui]

  On 12/22/2023 at 9:55 AM, Daresh said:

That's why I recommend deleting only old data, not all data. Some users complain that after clearing the guest table totally, the carts are not loaded. Loading carts may depend on the guest table (depending on PrestaShop version, I don't remember it now exactly).

I would modify the above queries this way:

DELETE FROM `ns_connections` WHERE `date_add` < '2023-01-01 00:00:00';
DELETE FROM `ns_connections_page` WHERE `time_start` < '2023-01-01 00:00:00';
DELETE FROM `ns_connections_source` WHERE `date_add` < '2023-01-01 00:00:00';
DELETE FROM `ns_guest` WHERE `id_guest` NOT IN (SELECT `id_guest` FROM `ns_connections`) AND `id_customer` = 0

 

Expand  

Guys, can you explain to me exactly what this SQL code does, and sorry for the inconvenience

[Daresh]

It deletes old data related to various statistics about customers visiting your shop.

[morad kablaoui]

  On 12/22/2023 at 10:08 AM, Daresh said:

It deletes old data related to various statistics about customers visiting your shop.

Expand  

Okay, thank you. I noticed that there is a date. Will you erase the data down to that date?

[morad kablaoui]