Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » RADICORE Installation Issues » MySQL error on Generate PHP
MySQL error on Generate PHP [message #3398] Wed, 30 January 2013 14:11 Go to previous message
johnftr is currently offline  johnftr
Messages: 14
Registered: January 2013
Junior Member
I have installed the radicore framework on a hosted enviroment.
I have logged in as MGR, created a new subsystem and imported my chosen database, tables and exported columns etc. I have defined a single relationship - all without problems.
When I came to the first Generate PHP on (any - this selected as example)the beat table to create a simple List1 task I get the following error:
2013-01-30 16:32:08
Fatal Error: MySQL: 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 '-menu.mnu_subsystem ON (mnu_subsystem.subsys_id=dict_database.subsys_id)
WHERE ' at line 4 (# 1064).
SQL query: SELECT SQL_CALC_FOUND_ROWS dict_table.database_id, dict_table.table_id, dict_database.subsys_id, mnu_subsystem.subsys_dir
FROM dict_table
LEFT JOIN dict_database ON (dict_database.database_id=dict_table.database_id)
LEFT JOIN web176-menu.mnu_subsystem ON (mnu_subsystem.subsys_id=dict_database.subsys_id)
WHERE dict_table.database_id='bdnw' AND dict_table.table_id='beat'
ORDER BY dict_table.database_id, dict_table.table_id asc
Error in line 577 of file '/home/sites/bdnw.org.uk/public_html/coords/radicore/include s/dml.mysqli.class.inc'.
Host Info: Localhost via UNIX socketServer Version: 5.5.25a-logClient Version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $, Character sets - client: utf8, - connection: utf8, - database: latin1, - server: latin1
PHP_SELF: /coords/radicore/dict/table(generate)a.php
CURRENT DIRECTORY: /home/sites/bdnw.org.uk/public_html/coords/radicore/dict
SERVER_NAME: bdnw.org.uk
HTTP_HOST: bdnw.org.uk
User Id: MGR
REQUEST_URI: /coords/radicore/dict/table(generate)a.php?session_name=menu 1
Page Stack:
[0] main_menu
[1] dictionary
[2] dict_table(list1)
[3] dict_table(enq1)
[4] dict_table(generate)a

Is this a hosting mysql issue? Any thoughts? It all works fine on my local machine,

Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Help ! Can not log In Radicore v1.76.0
Next Topic: RADICORE on openSusSE
Goto Forum:

Current Time: Sun May 22 15:56:25 EDT 2022

Total time taken to generate the page: 0.03071 seconds