Hey all
I have an error in my database which is screwing with my ability to export it. My actions_assignments table is giving me this error: #1033 - Incorrect information in files: '.*****\actions_assignment.frm'
Does anyone know what I can do to fix this? If it's the actions module that created this can I disable it, run update.php then delete the table and re-enable the module or soemthing?
Thanks! Leet
On Thu, Feb 26, 2009 at 9:29 PM, Ryan Thomson ryan@etrafficsolutions.com wrote:
Hey all
I have an error in my database which is screwing with my ability to export it. My actions_assignments table is giving me this error: #1033 - Incorrect information in files: '.*****\actions_assignment.frm'
Does anyone know what I can do to fix this? If it's the actions module that created this can I disable it, run update.php then delete the table and re-enable the module or soemthing?
This is a MySQL error, not Drupal's. It seems that the real file associated with that database table has been damaged.
If phpmyadmin can't repair the table you may need to drop it and create it from scratch (losing whatever it contains). The details depend on your Drupal version.
In some cases, this MySQL error message is misleading and the real problem is that your operating system's tmp directory is inaccessible.
Thanks! Leet -- [ Drupal support list | http://lists.drupal.org/ ]
Yeah I realize this is a database issue, but I was hoping given that a drupal module made the table 'actions_assignments' I was hoping someone could tell me which module made that table. My sql knowledge isn't awesome so I'm hesitant to just delete the table as I have no clue what it's used for or what I would build it back up with.
Cog Rusty wrote:
On Thu, Feb 26, 2009 at 9:29 PM, Ryan Thomson ryan@etrafficsolutions.com wrote:
Hey all
I have an error in my database which is screwing with my ability to export it. My actions_assignments table is giving me this error: #1033 - Incorrect information in files: '.*****\actions_assignment.frm'
Does anyone know what I can do to fix this? If it's the actions module that created this can I disable it, run update.php then delete the table and re-enable the module or soemthing?
This is a MySQL error, not Drupal's. It seems that the real file associated with that database table has been damaged.
If phpmyadmin can't repair the table you may need to drop it and create it from scratch (losing whatever it contains). The details depend on your Drupal version.
In some cases, this MySQL error message is misleading and the real problem is that your operating system's tmp directory is inaccessible.
Thanks! Leet -- [ Drupal support list | http://lists.drupal.org/ ]
On Fri, Feb 27, 2009 at 7:14 PM, Ryan Thomson ryan@etrafficsolutions.com wrote:
Yeah I realize this is a database issue, but I was hoping given that a drupal module made the table 'actions_assignments' I was hoping someone could tell me which module made that table. My sql knowledge isn't awesome so I'm hesitant to just delete the table as I have no clue what it's used for or what I would build it back up with.
I am guessing you are using Drupal 5. That table is created by the http://drupal.org/project/actions module, 5.x-2.{n} version. You can find details in the module's actions.install file.
Cog Rusty wrote:
On Thu, Feb 26, 2009 at 9:29 PM, Ryan Thomson ryan@etrafficsolutions.com wrote:
Hey all
I have an error in my database which is screwing with my ability to export it. My actions_assignments table is giving me this error: #1033 - Incorrect information in files: '.*****\actions_assignment.frm'
Does anyone know what I can do to fix this? If it's the actions module that created this can I disable it, run update.php then delete the table and re-enable the module or soemthing?
This is a MySQL error, not Drupal's. It seems that the real file associated with that database table has been damaged.
If phpmyadmin can't repair the table you may need to drop it and create it from scratch (losing whatever it contains). The details depend on your Drupal version.
In some cases, this MySQL error message is misleading and the real problem is that your operating system's tmp directory is inaccessible.
Thanks! Leet -- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Thanks!
Cog Rusty wrote:
On Fri, Feb 27, 2009 at 7:14 PM, Ryan Thomson ryan@etrafficsolutions.com wrote:
Yeah I realize this is a database issue, but I was hoping given that a drupal module made the table 'actions_assignments' I was hoping someone could tell me which module made that table. My sql knowledge isn't awesome so I'm hesitant to just delete the table as I have no clue what it's used for or what I would build it back up with.
I am guessing you are using Drupal 5. That table is created by the http://drupal.org/project/actions module, 5.x-2.{n} version. You can find details in the module's actions.install file.
Cog Rusty wrote:
On Thu, Feb 26, 2009 at 9:29 PM, Ryan Thomson ryan@etrafficsolutions.com wrote:
Hey all
I have an error in my database which is screwing with my ability to export it. My actions_assignments table is giving me this error: #1033 - Incorrect information in files: '.*****\actions_assignment.frm'
Does anyone know what I can do to fix this? If it's the actions module that created this can I disable it, run update.php then delete the table and re-enable the module or soemthing?
This is a MySQL error, not Drupal's. It seems that the real file associated with that database table has been damaged.
If phpmyadmin can't repair the table you may need to drop it and create it from scratch (losing whatever it contains). The details depend on your Drupal version.
In some cases, this MySQL error message is misleading and the real problem is that your operating system's tmp directory is inaccessible.
Thanks! Leet -- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Cog Rusty -
Ryan Thomson