Add tables to mySQL database for personal starter kitRSS

• • Reply
  antonbeerens

  None

  0 Points

  1 Post

  Add tables to mySQL database for personal starter kit

  Jul 23, 2007 06:56 PM|antonbeerens|LINK

  Hi,

  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. <div mce_keep="true">1. The unzip, setup and upload etc went ok. </div>
  2. <div mce_keep="true">I added some tables like role, user and userinroles to the table, and setup security and users</div>
  3. <div mce_keep="true">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'"</div>

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

  Kind regards,

    Anton 

   

• • Reply
  JoeBird

  None

  0 Points

  2 Posts

  Re: Add tables to mySQL database for personal starter kit

  Aug 28, 2007 03:18 AM|JoeBird|LINK

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

• • Reply
  stevedale

  Member

  22 Points

  128 Posts

  Re: Add tables to mySQL database for personal starter kit

  Sep 12, 2007 08:08 AM|stevedale|LINK

  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.

• • Reply
  den.taylor

  None

  0 Points

  2 Posts

  Re: Add tables to mySQL database for personal starter kit

  Oct 22, 2007 02:44 PM|den.taylor|LINK

  I am only aware of 1:

  http://www.mrwize.nu