There seems to be no mysql table for the query manager

[digitalmethodsinitiative]

There seems to be no mysql table for the query manager

[ErikBorra]

A migration guide has been implemented for those users who had DMI-TCAT installed before the query manager was implemented (6 March 2014). Please pull the latest source and run the following: cd dmi-tcat/helpers; php migrate.php. It will guide you through the migration process.

[supersambo]

Hi Erik,
thank you very much for the migrate script. I followed the instructions an altered all the tables. Unfortunatley the script seems to be unable to access mysql in the last step...

All you table definitions are OK
Migrating query bin definitions to new query manager.
importing from querybins.php

PHP Deprecated:  mysql_real_escape_string(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/supersambo/www/dmi-tcat/helpers/migrate.php on line 283
PHP Warning:  mysql_real_escape_string(): Access denied for user 'supersambo'@'localhost' (using password: NO) in /home/supersambo/www/dmi-tcat/helpers/migrate.php on line 283
PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/supersambo/www/dmi-tcat/helpers/migrate.php on line 283
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'twittercapture._tweets' doesn't exist' in /home/supersambo/www/dmi-tcat/helpers/migrate.php:294
Stack trace:
#0 /home/supersambo/www/dmi-tcat/helpers/migrate.php(294): PDOStatement->execute()
#1 /home/supersambo/www/dmi-tcat/helpers/migrate.php(220): binsToDb(Array, 'track')
#2 /home/supersambo/www/dmi-tcat/helpers/migrate.php(54): querybinsPhpToDb()
#3 {main}
  thrown in /home/supersambo/www/dmi-tcat/helpers/migrate.php on line 294

Best,
stephan

[ErikBorra]

Hi,

The conflict seems to be with mysql_real_escape_string in combination with the PDO queries. (We are in the process of moving mysql_query to PDO.) I now removed mysql_real_escape_string as your querybin names will be safe to use in mysql anyway. Please pull the source again and run the migrate script: php migrate.php. It should run fine now.

Best,

Erik

[supersambo]

YES!
it's (knocking-on-wood) working! Thank you very much for your patience and help!

Best,
stephan

[ErikBorra]

Thank you for offering to be an alpha user ;)

Cheers,

Erik