Creating Tables with Plugins Codex Page Incomplete

  • shagen

    (@shagen)


    12 years, 8 months ago

    Trying to write my first plugin that is compatible with 3.2.1 and trying to use the codex page to do so but am running into some issues. The following code creates the table no problem but it will not add data to the table itself as mentioned on the codex page. I am using the exact code from the codex page so the only variable is the register_activation_hook location. Does having this code before of after the function matter. Turned debugging on and got this error…

    Undefined variable: table_name

    WordPress database error Incorrect table name '' for query INSERT INTO(time,name,text) VALUES ('2011-08-21 05:57:06','Mr. WordPress','Congratulations, you just completed the installation!') made by activate_plugin, do_action, call_user_func_array, jal_install_data

    So here is the code that I have that is writing the table but not inserting the data…

    [code moderated - please follow http://codex.wordpress.org/Forum_Welcome#Posting_Code ]

    I am thinking there is a PHP problem. Not great at programming but am trying to learn. Just figured the stock code out of the gate would work or there would be a complete file in the codex that works. Have a feeling I have something out of order here.

    Can I make the $table_name global without interfering with other plugins. When I define the variable in the install data function and match the name everything seems to work fine. Why would the code be included if it does not work? Any help would be very very appreciated. Thanks for the time.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter shagen

    (@shagen)

    12 years, 8 months ago

    Here is the pastebin link for the code mentioned above…

    http://pastebin.com/xyHW7z1w

    Any help would be much appreciated. Thanks!

    Michael

    (@alchymyth)

    12 years, 8 months ago

    the only difference of your code to the codex example (as far as i can see) seems to be this line: (line 44 in the pastebin)

    $table_name = $wpdb->prefix . "bangit";

    which is possibly a table that has not been created.

    (the one created earlier in the code is:
    $table_name = $wpdb->prefix . "liveshoutbox"; )

    Thread Starter shagen

    (@shagen)

    12 years, 8 months ago

    ah… thought I changed that back. However the table is always created no matter what I name it. The issue lies with the fact that after the table is created there is no data getting inserted into it which is supposed to happen in the function named function jal_install_data() however I get an error saying that $table_name is undefined.

    When putting the following line in jal_install_data() the data inserts properly.

    $table_name = $wpdb->prefix . “liveshoutbox”;

    $table_name is therefore not global, correct? Why would they write it like that? Am I initializing something out of order. Or can a function live in a function? Maybe it is supposed to be in the initial function? Thoughts? Thanks for the replies so far. Really appreciated it.

    tbradley22

    (@tbradley22)

    12 years, 5 months ago

    i’m having the same issue. i used jal_install_data from the codex but the new table is empty.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Creating Tables with Plugins Codex Page Incomplete’ is closed to new replies.