Fork me on GitHub

database module : Table creation failed  Bottom

  • Hi everybody

    I'm using Postnuke 0.750 on Freebsd 5.4, Mysql 4.1.3, Apache 2, PHP 4-.4.4.0.

    I had some problem with the database module (cannot recall exactly what), and so I downloaded database1.0.zip from the chuck steel's website.

    Then I uninitialized my existing database, removed the database folder from /pn/modules, and put the new database (database1.0) folder into /pn/modules.

    Then I did a Regenerate in Administration -> Modules. But when I clicked 'Initialise', I got this error message:
    Table creation failed.

    I did the same thing on another server, and had no problem. The other server is almost identical except it is using Mysql 4.1.4.

    Can anybody help?


    Thank you.
  • I upgraded Mysql to 4.1.4. Still the same Table creation failed error.

    zzzzsg

    Hi everybody

    I'm using Postnuke 0.750 on Freebsd 5.4, Mysql 4.1.3, Apache 2, PHP 4-.4.4.0.

    I had some problem with the database module (cannot recall exactly what), and so I downloaded database1.0.zip from the chuck steel's website.

    Then I uninitialized my existing database, removed the database folder from /pn/modules, and put the new database (database1.0) folder into /pn/modules.

    Then I did a Regenerate in Administration -> Modules. But when I clicked 'Initialise', I got this error message:
    Table creation failed.

    I did the same thing on another server, and had no problem. The other server is almost identical except it is using Mysql 4.1.4.

    Can anybody help?


    Thank you.
  • Make sure that all of the database module's tables have been removed from your database using a tool like phpMyAdmin. Then try to initialize the module again.
  • thank you.

    Yeah, I realised that uninitializing the module actually remove the records but not the tables.
    Luckily, I have a backup.
    So I deleted the tables, click on Initialize and it worked.
    Then I import the records from the backup server using Mysql commands.

    But now, I am getting another error when trying to do a delete in the database module.

    Fatal error: Call to a member function on a non-object in /usr/local/www/pn/modules/database/pnuser.php on line 759

    I've no time to troubleshoot this, and will just live with this error, and use Mysql on the server to delete records.

    Thank you for replying once again.



    csteelatgburg

    Make sure that all of the database module's tables have been removed from your database using a tool like phpMyAdmin. Then try to initialize the module again.
  • where can I find the database module?
  • silverscout

    where can I find the database module?


    http://www.chucksteel.com/postnuke/
  • thanks

This list is based on users active over the last 60 minutes.