Unable to Add A New Page or Edit and save as a copy - Forum | JoomShaper
Staff replied SP Page Builder

Unable to Add A New Page or Edit and save as a copy

Asked by Giampiero 4 years ago Last activity 4 years ago

when i try to create a new page :

  • i edit an existing page and then save it with SAVE COPY
    or
  • if i create a new blank page.

after pressing the SAVE and CLOSE key, the pages do not exist in the list.

9 replies

Oldest first Newest first Most helpful
Andrew
4 years ago

Ive seen this one one of my installations. Which version of mySQL are you using?

Giampiero Asked this
4 years ago

Hello Andrew

$ mysqld --version

/usr/sbin/mysqld Ver 8.0.29-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu))

Rashida Rahman Staff
4 years ago

Hi,

Sorry for the inconvenience.

The 5 tables of sppagebuilder needs to be auto incremented. https://prnt.sc/26par6w

Would you please check if those table in your respective database has auto increment turned on for the primary keys or not?

Best Regards

Giampiero Asked this
4 years ago

mysql> DESCRIBE ggg_sppagebuilder;
+------------------+-----------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-----------------+------+-----+---------------------+-------+
| id | bigint unsigned | NO | PRI | NULL | |
| asset_id | int | NO | | 0 | |

Giampiero Asked this
4 years ago

mysql> SHOW TABLE STATUS LIKE 'ggg_sppagebuilder'\G

--------------------------------1. row -----------------------------

       Name: ggg_sppagebuilder

     Engine: InnoDB

    Version: 10

 Row_format: Dynamic

       Rows: 13

Avg_row_length: 32768

Data_length: 425984

Max_data_length: 0

Index_length: 0

  Data_free: 0

Auto_increment: NULL

Create_time: 2022-05-13 14:33:34

Update_time: 2022-05-13 18:51:02

 Check_time: NULL

  Collation: utf8_general_ci

   Checksum: NULL

Create_options:

    Comment:
Giampiero Asked this
4 years ago

the table sppagebuilder has the id field with PRIMARY KEY but Auto_increment: NULL ( is disabled)

Rashida Rahman Staff
4 years ago

Kindly, enable auto increment for the primary key of your all 5 sppagebuilder tables.

Giampiero Asked this
4 years ago

hi
after correcting a record with ID to 0, I was able to enable auto increment
ok work

Rashida Rahman Staff
4 years ago

Hi,

Glad that your issue has been solved:)

You may accept my answer in order to close the post.

Have a nice day!

Log in to reply.