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}
Database Error: 1064 on database Backup
- support
- Site Admin
- Posts: 6216
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Error: 1064 on database Backup
Can't reproduce it. Do you have extra custom tables in your database?
-
- 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
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
Matt
- support
- Site Admin
- Posts: 6216
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database Error: 1064 on database Backup
Try to create backup using phomyadmin.