DB Table is not created


  • Your avatar
    seyi    
     6 years ago
    0

    Dear Sir,

    My Joomla version is 1.5
    Virtuemart version.1.1.13
    DataBase prefix is not "jos"


    I could successfully install AwoCoupon.
    But when I tried to create coupon, give error code as"DB function failed with error number 1146"
    I checked the DB tables and found the "awe" tables are not created.
    I wonder if it is due to that my DataBase prefix is not"jos"
    I will be very happy if I can get advise how I can solve it.

    Thank you in adavance for your co-opearation.

    ump
  • Your avatar
    seyi    
     6 years ago
    0

    That is strange. It should have installed even though your prefix is not jos_. I use joomla's standard convension to install the tables, which would account for non standard prefixes.

    Well you can manually install the tables. Open the file www/administrator/components/com_awocoupon/install.mysql.sql. Change all the table prefixes from "#__" to "yourprefix_". So for example #__awocoupon would become yourprefix_awocoupon. Then run the queries in your db.

    That should do it.
  • Default avatar
    ump    
     6 years ago
    0

    Dear Mr.Seyi,

    As per your advise I could create the tables of awocoupon.
    It worrked pefectly.
    I am very happy and excited with this component. It did
    brillint work.
    Great work.

    Thank you.

    ump
  • Default avatar
    merrante    
     6 years ago
    0

    I made the changes in the install.mysql.sql file. How do I create the tables. I dont understand how to "Then run the queries in your db."

    I have access to phpmyadmin if that helps.

    thanks.
  • Your avatar
    seyi    
     6 years ago
    0

    Hi, maybe this can help. http://community.mybb.com/showthread.php?tid=4720

    Pretty much within phpmyadmin, you want to select the correct database, then click on any table to show the tabs, and then select the Sql tab. There you can enter the queries and run them.
  • Default avatar
    merrante    
     6 years ago
    0

    Thanks for the help. Im new to sql commands.

    If its not to much, can you give me the proper formatting to use for one of the tables out of install.mysql.sql as an example.

    I have edited the install.mysql.sql file to reflect the database.

    CREATE TABLE IF NOT EXISTS josvianney_awocoupon_product (
    `id` int(16) NOT NULL auto_increment,
    `coupon_id` varchar(32) NOT NULL default '',
    `product_id` INT NOT NULL,
    PRIMARY KEY (`id`)
    );


    What would this section look like as a Sql Query? Thanks.

  • Your avatar
    seyi    
     6 years ago
    0

    Yes, the edit is correct. You just need to copy, paste and run. What you posted is an sql query.