MX Query Builder Forum :: Error: Cannot create table??

This thread was displayed: 0 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
Christian Taylor
04-01-2007 04:23:17 GMT +2

 

I keep getting this error message when trying to use QuB:

There have been some problems connection to your database:
Cannot create table qub3_queries_que
Cannot create table qub3_relations_rel
Cannot create table qub3_settings_set
Cannot select from qub3_queries_que
Please see the manual for possible reason and solution

I am using PHP/MySql and my connection user has "All" privilages. I am using DW8.0.2 and MX Query Builder Pro-3.7.1

Has anyone seen this before? I've tried everything I can think of to get this working. I have tested all my db connections and my database does not have the "qub" tables.
Back | Reply | Quote | Top
Razvan Racasanu[InterAKT]Adobe Systems Romania staff
04-13-2007 17:44:36 GMT +2

Hello,

Try running manually the following SQL statements to create the necessary QuB tables:

CREATE TABLE `qub3_queries_que` (
  `name_que` varchar(50) NOT NULL default '',
  `query_que` longtext NOT NULL,
  `desc_que` longtext NOT NULL,
  `tables_que` longtext NOT NULL,
  `version_que` varchar(10) NOT NULL default ''
);

CREATE TABLE `qub3_relations_rel` (
  `table1_rel` varchar(100) NOT NULL default '',
  `table2_rel` varchar(100) NOT NULL default '',
  `t1id_rel` varchar(100) NOT NULL default '',
  `t2id_rel` varchar(100) NOT NULL default '',
  `type_rel` varchar(10) NOT NULL default '',
  `restrict_rel` int(11) NOT NULL default '0'
);

CREATE TABLE `qub3_settings_set` (
  `setting_name_set` varchar(32) NOT NULL default '',
  `setting_value_set` varchar(32) NOT NULL default ''
);

Regards,
Razvan RACASANU
Reply | Quote | Top
Messages 1 to 1 from 1
Forums
MX Query Builder 3.7.1
© Adobe Systems Romania. All rights reserved.