MaheshWaidande commented 8 years ago

Hi All

I am working on deploying/installing pressflow 6 on ppc64le architecture. I am using Ubuntu 14.04(trusty) on top of ppc64le hardware, while installing pressflow6 I am facing below warnings, which interrupts the installation process.

• User warning: 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM pf_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in _db_query() (line 170 of /var/www/drupal/includes/database.mysql.inc). • User warning: 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM pf_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in _db_query() (line 170 of /var/www/drupal/includes/database.mysql.inc).

For more information I have attached snapshot of warnings along this post.

Below are machine details which I am using, $ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.3 LTS Release: 14.04 Codename: trusty

$ uname -a Linux test-local-machine-1 3.19.0-15-generic #15-Ubuntu SMP Thu Apr 16 23:32:13 UTC 2015 ppc64le ppc64le ppc64le GNU/Linux

Any pointers/suggestions on above warnings will be great help.

fluxsauce commented 8 years ago

Hi Mahesh,

Thanks for your interest, sorry to hear you're having trouble. If you try the installation without the table prefixes, does it succeed?

Out of curiosity, why not use Drupal / Pressflow 7 for a new install? Drupal 6 will be end-of-lifed when Drupal 8 is released in two weeks.

MaheshWaidande commented 8 years ago

Hi fluxsauce,

As you suggested I removed table prefixes and try to install pressflow6 on Ubuntu 14.04 (trusty) machine but still I am getting same warnings which interrupts an installation process.

I am getting below warnings after removing table prefix, • User warning: 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in _db_query() (line 170 of /var/www/drupal/includes/database.mysql.inc). • User warning: 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in _db_query() (line 170 of /var/www/drupal/includes/database.mysql.inc).

Below are stack trace and other debugging information which I have extracted/ gathered using API’s provided by php,

Query : SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 Error : 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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1

//Output of 'debug_print_backtrace()'

0 _db_query(SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1) called at [/var/www/drupal/includes/database.mysql.inc:292]

1 db_query_range(SELECT * FROM {menu_router} WHERE path IN () ORDER BY fit DESC, Array (), 0, 1) called at [/var/www/drupal/includes/menu.inc:317] #2 menu_get_item() called at [/var/www/drupal/includes/menu.inc:1539]

3 menu_set_active_trail() called at [/var/www/drupal/includes/menu.inc:1596]

4 menu_get_active_trail() called at [/var/www/drupal/includes/menu.inc:1631]

5 menu_get_active_title() called at [/var/www/drupal/includes/path.inc:235]

6 drupal_get_title() called at [/var/www/drupal/includes/theme.maintenance.inc:235]

7 template_preprocess_maintenance_page(Array ([template_files] => Array (),[content] => ,[show_blocks] => 1,[show_messages] => 1,[zebra] => odd,[id] => 1,[directory] => themes/garland,[is_admin] => ,[is_front] => ,[logged_in] => ,[db_is_active] => ,[left] =>

Choose language
Verify requirements
Set up database
Install site
Configure site
Finished

,[right] => ,[header] => ,[footer] => ,[layout] => left), maintenance_page)

8 call_user_func_array(template_preprocess_maintenance_page, Array ([0] => Array ([template_files] => Array (),[content] => ,[show_blocks] => 1,[show_messages] => 1,[zebra] => odd,[id] => 1,[directory] => themes/garland,[is_admin] => ,[is_front] => ,[logged_in] => ,[db_is_active] => ,[left] =>

Choose language
Verify requirements
Set up database
Install site
Configure site
Finished

,[right] => ,[header] => ,[footer] => ,[layout] => left),[1] => maintenance_page)) called at [/var/www/drupal/includes/theme.inc:710]

9 theme(maintenance_page, ) called at [/var/www/drupal/install.php:855]

10 install_tasks(default, profile-install-batch) called at [/var/www/drupal/install.php:167] #11 install_main() called at [/var/www/drupal/install.php:1203]

//Output of 'var_dump(debug_backtrace())' array(12) { [0]=> array(4) { ["file"]=> string(43) "/var/www/drupal/includes/database.mysql.inc" ["line"]=> int(292) ["function"]=> string(9) "_db_query" ["args"]=> array(1) { [0]=> &string(71) "SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1" } } [1]=> array(4) { ["file"]=> string(33) "/var/www/drupal/includes/menu.inc" ["line"]=> int(317) ["function"]=> string(14) "db_query_range" ["args"]=> array(4) { [0]=> &string(62) "SELECT * FROM {menu_router} WHERE path IN () ORDER BY fit DESC" [1]=> &array(0) { } [2]=> &int(0) [3]=> &int(1) } } [2]=> array(4) { ["file"]=> string(33) "/var/www/drupal/includes/menu.inc" ["line"]=> int(1539) ["function"]=> string(13) "menu_get_item" ["args"]=> array(0) { } } [3]=> array(4) { ["file"]=> string(33) "/var/www/drupal/includes/menu.inc" ["line"]=> int(1596) ["function"]=> string(21) "menu_set_active_trail" ["args"]=> array(0) { } } [4]=> array(4) { ["file"]=> string(33) "/var/www/drupal/includes/menu.inc" ["line"]=> int(1631) ["function"]=> string(21) "menu_get_active_trail" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(33) "/var/www/drupal/includes/path.inc" ["line"]=> int(235) ["function"]=> string(21) "menu_get_active_title" ["args"]=> array(0) { } } [6]=> array(4) { ["file"]=> string(46) "/var/www/drupal/includes/theme.maintenance.inc" ["line"]=> int(235) ["function"]=> string(16) "drupal_get_title" ["args"]=> array(0) { } } [7]=> array(2) { ["function"]=> string(36) "template_preprocess_maintenance_page" ["args"]=> array(2) { [0]=> &array(16) { ["template_files"]=> array(0) { } ["content"]=> string(0) "" ["show_blocks"]=> bool(true) ["show_messages"]=> bool(true) ["zebra"]=> string(3) "odd" ["id"]=> int(1) ["directory"]=> string(14) "themes/garland" ["is_admin"]=> bool(false) ["is_front"]=> bool(false) ["logged_in"]=> bool(false) ["db_is_active"]=> bool(false) ["left"]=> string(236) "

Choose language
Verify requirements
Set up database
Install site
Configure site
Finished

" ["right"]=> NULL ["header"]=> NULL ["footer"]=> NULL ["layout"]=> string(4) "left" } [1]=> &string(16) "maintenance_page" } } [8]=> array(4) { ["file"]=> string(34) "/var/www/drupal/includes/theme.inc" ["line"]=> int(710) ["function"]=> string(20) "call_user_func_array" ["args"]=> array(2) { [0]=> &string(36) "template_preprocess_maintenance_page" [1]=> &array(2) { [0]=> &array(16) { ["template_files"]=> array(0) { } ["content"]=> string(0) "" ["show_blocks"]=> bool(true) ["show_messages"]=> bool(true) ["zebra"]=> string(3) "odd" ["id"]=> int(1) ["directory"]=> string(14) "themes/garland" ["is_admin"]=> bool(false) ["is_front"]=> bool(false) ["logged_in"]=> bool(false) ["db_is_active"]=> bool(false) ["left"]=> string(236) "

Choose language
Verify requirements
Set up database
Install site
Configure site
Finished

" ["right"]=> NULL ["header"]=> NULL ["footer"]=> NULL ["layout"]=> string(4) "left" } [1]=> string(16) "maintenance_page" } } } [9]=> array(4) { ["file"]=> string(27) "/var/www/drupal/install.php" ["line"]=> int(855) ["function"]=> string(5) "theme" ["args"]=> array(2) { [0]=> &string(16) "maintenance_page" [1]=> &bool(false) } } [10]=> array(4) { ["file"]=> string(27) "/var/www/drupal/install.php" ["line"]=> int(167) ["function"]=> string(13) "install_tasks" ["args"]=> array(2) { [0]=> &string(7) "default" [1]=> &string(21) "profile-install-batch" } } [11]=> array(4) { ["file"]=> string(27) "/var/www/drupal/install.php" ["line"]=> int(1203) ["function"]=> string(12) "install_main" ["args"]=> array(0) { } } }

Sorry, for pasting such a large data here, I want uploads this data as a text file but as I don’t have write permission on this repository so I can’t upload it. I also attached snapshot of warnings which I have encountered while installing pressflow6.

I am working on deploying drupal6 juju charm on ppc64le https://bugs.launchpad.net/charms/+source/drupal6/+bug/1371339 , internally drupal6 juju charm clone pressflow6 and use it, that is the reason I stick with pressflow6 and not going for higher versions.

I spend a lot of time on debugging this issue. Any pointers/suggestions on this issue are welcome.

pressflow-remove_table-prefix-2

pwolanin commented 8 years ago

You have an empty IN() conditions, suggesting you are missing all the menu masks used for constructing the list of candidate paths.

If you google the error message, many of the fixes involve problems with the user's browser not accepting cookies, wrong cookie domain, etc.

As above - creating a new Drupal 6 site is a poor choice at this point in time. In any case you'd be better off manually installing than using some juju that's obviously broken and will cause you pain going forward.