Why the database unable to create?

[edhan]

Hi

I am trying to create a table in wordpress blog but it does not seem to be able to do so. Wondering if anyone can tell me what is wrong with this code. Thanks!

function sa_install(){
   global $table_prefix, $wpdb, $user_level;

   $table_name = $table_prefix . "record_display";

   if($wpdb->get_var("show tables like '$table_name'") != $table_name){

   $sql = "CREATE TABLE ".$table_name." (
   id mediumint(9) NOT NULL auto_increment,
   record_id int(11) NOT NULL default '0',
   record_display text NOT NULL,
   record_description text,
   PRIMARY KEY  (`id`)
   );";

[wige]

Try adding the following:

$results=mysql_query($query);
if ($results) {
echo "yay";
} else {
echo mysql_error();
}

My guess would be that the user your PHP script uses to access the database doesn't have CREATE permissions on the database, which is common since this could be a security issue.

[edhan]

Hi wige

I have added that as you have said, it doesn't give me the echo or the error. Check the database using phpMyAdmin, the table is not created.

Just letting you know that it is activated in the wordpress plugin. Might be why it did not show the echo yay when activated.

Update:

When I went to the plugin configuration, it shows:
The database table is not installed, check your db permissions and activate the plugin again or run the following code in phpMyAdmin

How to I change the db permission? As I will be using alot of this plugin, I do not want to manually add the code in phpMyAdmin.

[edhan]

Hi

Just letting you know that I have resolved this issue and here is how I have solved the mystery. I just need to add the command to access the database (wp-config.php in wordpress) and it works.