By monkfish4d on

Hello,

On another thread I was advised to clear the sessions table - how do I do this?

Do I need phpMyAdmin? or can I do it using the drupal admin interface...

Cheers,
N

⋅ Categories: Drupal 6.x

Comments

Fluffy Convict’s picture

Fluffy Convict commented

When you're new to Drupal, you really might want to take a look at it's code and database. It will teach you a lot about it's inner workings and it will help you building your site. My point is - you need phpMyAdmin anyway, so please install it if you haven't done so already. Then navigate to the sessions table, en click the "empty" tab. Hope that helps :-)

alextronic’s picture

alextronic commented

hmm... I did that, but it didn't solve my sql error (Cannot add or update a child row: a foreign key constraint fails (`wideawake_civicrm/civicrm_contribution_page`, CONSTRAINT `FK_civicrm_contribution_page_contribution_type_id` FOREIGN KEY (`contribution_type_id`) REFERENCES `civicrm_contribution_type` (`id`)) query: INSERT INTO wideawake_civicrm.civicrm_contribution_page (affiliate_id) VALUES ( 6 ) in /home/mmichel/www/wide-awake/modules/contemplate/contemplate.module(851) : eval()'d code on line 3.).
Thanx anyway, is there a way to get rid of that error message?

jainrutgers’s picture

jainrutgers commented

Export your sql file..and then open it in any editor....Look for " INSERT INTO wideawake_civicrm.civicrm_contribution_page (affiliate_id) VALUES ( 6 ) in /home/mmichel/www/wide.."
and simply remove that.

Note: It might can create some problem. Removing anything else then cache table of which you are not sure can put in trouble.

Better way. As I can see from the error its related to CivicCrm module. So got to module list uncheck it first. Then Uninstall it from the admin.(this will remove the table from database). Then if you want you can remove the CiviCRM folder from the modules folder. Now before exporting just clear your all cache table. And now if you import it ,,,it will work fine...

Hope that will help

Chetan

dwongu’s picture

dwongu commented

I have Drupal 6 installed (with Commons) and would like to clear the 'sessions' table to address some issues, but - well, there is no "sessions" table in my phpmyadmin??? Has this table been changed in the later releases of Drupal?