Unable To Add A New Page Or Edit And Save As A Copy - Question | JoomShaper

Unable To Add A New Page Or Edit And Save As A Copy

G

Giampiero

SP Page Builder 1 year 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.

0
9 Answers
A
Andrew
Accepted Answer
1 year ago #68804

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

0
G
Giampiero
Accepted Answer
1 year ago #68822

Hello Andrew

$ mysqld --version

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

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 year ago #68825

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

0
G
Giampiero
Accepted Answer
1 year ago #68834

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

0
G
Giampiero
Accepted Answer
1 year ago #68835

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:
0
G
Giampiero
Accepted Answer
1 year ago #68836

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

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 year ago #68838

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

0
G
Giampiero
Accepted Answer
1 year ago #68853

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

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 1 year ago #71118

Hi,

Glad that your issue has been solved:)

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

Have a nice day!

0