Add tables to mySQL database for personal starter kit RRS feed

  • Question

  • User139202609 posted


    I am trying to get the personal starter kit working, so far no luck. This is what I have done: btw I am using "Personal Site Starter Kit for MySQL v4.x-v5.x.zip" this is the starter kit for mySQL.

    1. 1. The unzip, setup and upload etc went ok.
    2. I added some tables like role, user and userinroles to the table, and setup security and users
    3. But then I got the error that the album and photos tables are missing. However I cannot find the SQL string to add this table to the database. I tried to do this manually by looking at the code but know I got the error "MySql.Data.MySqlClient.MySqlException: Unknown column 'Photos.OwnerID' in 'where clause'"

    Does anyone what needs to be added or where to get the mySQL string to add all tables to the database?

    Kind regards,



    Monday, July 23, 2007 6:56 PM

All replies

  • User860753258 posted

    Anyone know of a Personal Site Starter Kit for MySQL written in VB?

    Tuesday, August 28, 2007 3:18 AM
  • User128688735 posted

    I had a similar problem and noticed that the tables in the code started with uppercase and the tables in the database were in lower case - changing it fixed the problem.

    Wednesday, September 12, 2007 8:08 AM
  • User1972877376 posted

    I am only aware of 1:


    Monday, October 22, 2007 2:44 PM