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.
<div mce_keep="true">1. The unzip, setup and upload etc went ok. </div>
<div mce_keep="true">I added some tables like role, user and userinroles to the table, and setup security and users</div>
<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?
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.
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.
Does anyone what needs to be added or where to get the mySQL string to add all tables to the database?
Kind regards,
Anton
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?
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.
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