CREATE TABLE Failed

  • Resolved mitrawings

    (@mitrawings)


    4 years, 10 months ago

    Hye, Peter!

    I do not know why but I am unable to create new tables. Every time I am trying to create a new table the plugin shows that CREATE TABLE Failed.

    At the bottom of the page, I am getting this above-mentioned message

    “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘NOT NULL,dealername varchar NOT NULL,dealeremail tinytext NOT NULL,`dealermo’ at line 1″

    I do not understand what I am doing wrong. Uninstalled and reinstalled the plugin the same result.
    BTW I am using a managed WordPress!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Mitra,

    Can you click on button “Show CREATE TABLE script”, then button “copy to clipboard” and finally paste the create table statement into a message? Let’s check the SQL first…

    Thanks,
    Peter

    Thread Starter mitrawings

    (@mitrawings)

    CREATE TABLE dealerdetails
    (dealerid tinyint NOT NULL
    ,gstno tinytext NOT NULL
    ,orgname varchar NOT NULL
    ,dealername varchar NOT NULL
    ,dealeremail tinytext NOT NULL
    ,dealermobile tinyint NOT NULL
    ,dealeraddress text NOT NULL
    ,dealerpincode tinyint NOT NULL
    ,note tinytext NULL
    ,PRIMARY KEY (dealerid)
    );

    CREATE UNIQUE INDEX dealerid ON dealerdetails (dealerid);

    Thanks for your reply. Here it goes

    Thread Starter mitrawings

    (@mitrawings)

    I found a way out of the issue.
    I had to add one column at a time and then save the table design then drop the table and finally create the table again….

    Exhausting
    However thanks for your time

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Good you found a solution Mitra! ?? Let me know I can help.

    Best regards,
    Peter

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘CREATE TABLE Failed’ is closed to new replies.

Tags