Hey all, I'm writing an abstraction layer for mssql and got the system up and working minus the left hand menu, it shows only 2 items if i clear the cache table but then after reloading it goes away again. Can someone point me in the right direction in the code? Joel Penner Volt Microsoft Open Source Software Lab
Quoting "Joel Penner (Volt)" <a-joelpe@microsoft.com>:
Hey all, I'm writing an abstraction layer for mssql and got the system up and working minus the left hand menu, it shows only 2 items if i clear the cache table but then after reloading it goes away again. Can someone point me in the right direction in the code?
Do you have the devel module[1] installed? You can see every query with it. [1] http://drupal.org/project/devel Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Well, I have control over the driver and can see all of the queries, but I don't know which ones to look for, that's the problem -----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Tuesday, July 22, 2008 12:20 PM To: development@drupal.org Subject: Re: [development] Left menu missing Quoting "Joel Penner (Volt)" <a-joelpe@microsoft.com>:
Hey all, I'm writing an abstraction layer for mssql and got the system up and working minus the left hand menu, it shows only 2 items if i clear the cache table but then after reloading it goes away again. Can someone point me in the right direction in the code?
Do you have the devel module[1] installed? You can see every query with it. [1] http://drupal.org/project/devel Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Quoting "Joel Penner (Volt)" <a-joelpe@microsoft.com>:
Well, I have control over the driver and can see all of the queries, but I don't know which ones to look for, that's the problem
The devel module will also give you a hint as to from where the query comes as well as how long the query took. Which Drupal version are you targeting your work? My guess is the cache_menu table is missing data. It holds all of the menu array. Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Yes, it's mostly blank, do you know if my database driver would have caused this? Where is this data gathered from? -----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Tuesday, July 22, 2008 2:53 PM To: development@drupal.org Subject: Re: [development] Left menu missing Quoting "Joel Penner (Volt)" <a-joelpe@microsoft.com>:
Well, I have control over the driver and can see all of the queries, but I don't know which ones to look for, that's the problem
The devel module will also give you a hint as to from where the query comes as well as how long the query took. Which Drupal version are you targeting your work? My guess is the cache_menu table is missing data. It holds all of the menu array. Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Quoting "Joel Penner (Volt)" <a-joelpe@microsoft.com>:
Yes, it's mostly blank, do you know if my database driver would have caused this? Where is this data gathered from?
The cache_menu table holds the result from the menu module calling every hook_menu implementation and then calling cache_set with the serialized array data when there is no cache_menu data. The menu module may also call cache_set when there may be a need for an update. The data type for the columns must be large enough to hold the serialized data. The devel module will give you clues and I highly suggest it for any development of a module. Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Looks like I found the problem. If the database returns NULL if there are no more rows to retrieve and that is then passed on to the app, it causes lots of problems, fixed -----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Wednesday, July 23, 2008 6:53 AM To: development@drupal.org Subject: Re: [development] Left menu missing Quoting "Joel Penner (Volt)" <a-joelpe@microsoft.com>:
Yes, it's mostly blank, do you know if my database driver would have caused this? Where is this data gathered from?
The cache_menu table holds the result from the menu module calling every hook_menu implementation and then calling cache_set with the serialized array data when there is no cache_menu data. The menu module may also call cache_set when there may be a need for an update. The data type for the columns must be large enough to hold the serialized data. The devel module will give you clues and I highly suggest it for any development of a module. Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
participants (2)
-
Earnie Boyd -
Joel Penner (Volt)