SQLite Error when inserting new post

Question

SQLite Error when inserting new post

Closed this issue 11 years ago · 11 comments

moshohayeb commented 12 years ago

Hello, I get the following error when trying to write a new blog post:
Error:
Object: object

Answer 1 · 2013-06-22T15:27:46.000Z

Can you view the logs and see what the actual error is? Should have an exception thrown in the api/postcontroller

Answer 2 · 2013-06-22T19:34:01.000Z

Hi, here is the full log
http://pastebin.com/ZcwC2TBz

Answer 3 · 2013-06-22T23:36:49.000Z

table posts has no column named publish_date

Looks like maybe it didn't install properly. I would drop the db and install again.

Answer 4 · 2013-06-23T20:26:38.000Z

Closing but please follow up if this doesn't fix it.

Answer 5 · 2013-07-06T00:44:58.000Z

I can confirm, the problem is not fixed :
table posts has no column named publish_date
when trying to publish a new post.

Viewing the sqlite file, here is the posts table :

0|id|integer|0||1
1|title|varchar|0||0
2|slug|varchar|0||0
3|content|text|0||0
4|image|varchar|0||0
5|type|varchar|0||0
6|active|integer|0|'0'|0
7|created_at|datetime|0||0
8|updated_at|datetime|0||0

So yes, there's no publish_date field.

Answer 6 · 2013-07-06T04:46:04.000Z

@grena Did you just install wardrobe? It appears I added that col on june 4th.
https://github.com/ericbarnes/wardrobe/blob/master/app/database/migrations/2013_05_31_140553_create_posts_table.php#L22

Does anything stand out to you that would cause that field to not be added when the migration is added?

Answer 7 · 2013-07-06T11:13:59.000Z

Hello @ericbarnes,
Yes I just did a fresh install yesterday by cloning the repo. Here are the steps I did

git clone https://github.com/ericbarnes/wardrobe.git myproject && cd myproject
composer.phar install
**Here  I changed app/config/database.php to switch to sqlite**
cd ..
chown -R www-data:www-data myproject

And I ran the installation.
Did I miss a step ?

Answer 8 · 2013-07-06T23:45:53.000Z

Looks correct. I will do some testing and see whats up.

Answer 9 · 2013-07-07T00:03:45.000Z

I just did a fresh install with sqlite and didn't have any issues. See the publish_date?

You have any thoughts on what the issue could be?

Answer 10 · 2013-07-07T00:08:01.000Z

Sorry for spamming the thread :) I think I have it figured it out now. The default sqlite file wasn't empty from when I first started building the app. So the migration never ran since all the tables was already created.

Answer 11 · 2013-07-07T11:47:55.000Z

Hi,
I just tested right now and it works, the bug is fixed :)
Thank you for your investigation !
Cheers.