Page 1 of 1

Database Error: 1064 on database Backup

Posted: 24 Apr 2024, 02:07
by M1S1L
Sergey,

When I try to make database backup using database backup tool I get the following error:

Database Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1' at line 1
Query: SHOW CREATE TABLE View 1
Page: /pm/tst/index.php?module=tools/db_backup&action=backup&token=kWpT9Ji2nf
#0 includes/functions/database.php(99): mysqli_query()
#1 includes/classes/backup.php(105): db_query()
#2 modules/tools/actions/db_backup.php(78): backup->create()
#3 index.php(31): require('...')
#4 {main}

Re: Database Error: 1064 on database Backup

Posted: 24 Apr 2024, 19:08
by support
Can't reproduce it. Do you have extra custom tables in your database?

Re: Database Error: 1064 on database Backup

Posted: 26 Apr 2024, 20:23
by M1S1L
Only tables in db are the ones I created through Application Structure > Entities List. I can send you the sql file if you want to take a look at it.

Matt

Re: Database Error: 1064 on database Backup

Posted: 26 Apr 2024, 20:46
by support
Try to create backup using phomyadmin.