Database error

Discuss everything related to ApPHP DataGrid Wizard utility. All versions. Any questions related to the ApPHP DataGrid Wizard developing or using should be posted to this forum.

Moderator: alexandrleonenko

norspeed Keith
Newbie
Newbie
Posts: 2
Joined: Nov 28th, '13, 10:05

Database error

Postby norspeed Keith » Nov 28th, '13, 10:13

Database error:

I have the following error:

SCRIPT: /admin/system/datagrid_wizard.php

ERROR LINE: 287

ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-datagrid' at line 1

What does this mean ?

-----------------------------------------------------
MY DATABASE TABLE BELOW.

New
<DB_PREFIX>admins
<DB_PREFIX>calendar
<DB_PREFIX>countries
<DB_PREFIX>datagrid_pages
<DB_PREFIX>dg_wizard_details_keys
<DB_PREFIX>dg_wizard_fields
<DB_PREFIX>dg_wizard_filtering
<DB_PREFIX>dg_wizard_foreign_keys
<DB_PREFIX>dg_wizard_settings
<DB_PREFIX>dynamic_pages
<DB_PREFIX>email_templates
<DB_PREFIX>events
<DB_PREFIX>events_categories
<DB_PREFIX>events_locations
<DB_PREFIX>events_users
<DB_PREFIX>file_types
<DB_PREFIX>gallery_albums
<DB_PREFIX>gallery_images
<DB_PREFIX>menu
<DB_PREFIX>menu_access_rights
<DB_PREFIX>modules
<DB_PREFIX>news
<DB_PREFIX>settings
<DB_PREFIX>static_pages
<DB_PREFIX>system_logs
<DB_PREFIX>test
<DB_PREFIX>test_1
<DB_PREFIX>test_countries
<DB_PREFIX>users
<DB_PREFIX>users_groups
phpap_admins
phpap_calendar
phpap_countries
phpap_datagrid_pages
phpap_dg_wizard_details_keys
phpap_dg_wizard_fields
phpap_dg_wizard_filtering
phpap_dg_wizard_foreign_keys
phpap_dg_wizard_settings
phpap_dynamic_pages
phpap_email_templates
phpap_events
phpap_events_categories
phpap_events_locations
phpap_events_users
phpap_file_types
phpap_gallery_albums
phpap_gallery_images
phpap_menu
phpap_menu_access_rights
phpap_modules
phpap_news
phpap_settings
phpap_static_pages
phpap_system_logs
phpap_test
phpap_test_1
phpap_test_countries
phpap_users
phpap_users_groups

administrator
Site Admin
Site Admin
Posts: 6001
Joined: Jan 7th, '09, 23:18
Contact:

Re: Database error

Postby administrator » Dec 1st, '13, 07:57

Do you use "-" sign in database tables? Remove them.
We'll fix this issue soon and re-upload script.


Return to “ApPHP DataGrid Wizard {developers/users}”