Database Error: 1064 on database Backup

Any critical bugs will be fixed within 24-48 hours.
Post Reply
M1S1L
Posts: 36
Joined: 31 Dec 2021, 06:13
Name: Matt Lichtenwalter
Location: Salt Lake City, USA
Company Name: Commotion Interactive
Contact:

Database Error: 1064 on database Backup

Post 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}
User avatar
support
Site Admin
Posts: 6206
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database Error: 1064 on database Backup

Post by support »

Can't reproduce it. Do you have extra custom tables in your database?
M1S1L
Posts: 36
Joined: 31 Dec 2021, 06:13
Name: Matt Lichtenwalter
Location: Salt Lake City, USA
Company Name: Commotion Interactive
Contact:

Re: Database Error: 1064 on database Backup

Post 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
User avatar
support
Site Admin
Posts: 6206
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database Error: 1064 on database Backup

Post by support »

Try to create backup using phomyadmin.
Post Reply