• Hello,
    I receive a database error when trying to add a new course:
    [Table ‘Sql1005795_1.wp870_wpcm_courses’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp870_wpcm_courses

    [Table ‘Sql1005795_1.wp870_wpcm_courses’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp870_wpcm_courses

    [Table ‘Sql1005795_1.wp870_wpcm_courses’ doesn’t exist]
    SELECT * FROM wp870_wpcm_courses

    Is there a solution for this issue?
    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Also getting the same error. I looked at the MySql database table and the *wpcm_courses table is not being generated. All the other tables are being generated however such as lecturers etc… It seems that the function that creates the table and inserts the new record for a course is not getting the variable value to instigate the routine in the function do it. If we knew exactly what the column names are that the table creates, we could just create a new table with the columns and then see what the values are that are being saved. Then we can determine what variable is failing or not receiving the value required to create the table. I am still looking at the code to find out what is going on exactly. My forte is not PHP. Maybe it’s a WP version conflict or a MySql version deficiency. I wanted to ask what the minimum versions of these environments does the plugin rely on. no specs define such however.

    Need to know:

    What version of PHP is required by the plugin.

    What version of WP was this plugin intended for.

    What version of MySql was this plugin intended to work on.

    Is there mods to functions that can resolve this issue.

    Yeah I think this plugin was intended to work on an old version of WordPress. I’m sure that it can be modified to work though.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database error’ is closed to new replies.