Login     Sign up
Help me!! SQL query error!
Pepe (@pslogc)
Join date: Sep 16th 2010
Community posts: 3
View Profile
Send Message

Hi,

Im a newbie.
I have error when I try to publish on dasboard, upload a photo, insert a new blog.

Any ideas?

Thanks

174 months ago
Ian (@eeji)
Join date: Aug 3rd 2010
Community posts: 107
View Profile
Send Message

what error message do you get?

174 months ago
Pepe (@pslogc)
Join date: Sep 16th 2010
Community posts: 3
View Profile
Send Message

The same error always:

SQL query error!

174 months ago
adil (@adil)
Join date: May 9th 2010
Community posts: 202
View Profile
Send Message

type the exact message so we can help (remove the site name or server name only)

174 months ago
Terry Wang (@twang6831)
Join date: Sep 28th 2010
Community posts: 16
View Profile
Send Message

Did you install 3.30? if so, I guess nothing works. This error is due to "insert" does not provide enough arguments as many table define fields without default values.

174 months ago
obi mark (@daddycool)
Join date: Dec 8th 2010
Community posts: 7
View Profile
Send Message

Hello Adil, i have a similar error as listed below;

SQL query error!
Error infomation:[SQL]
update jcow_forum_posts set stream_id='27' where id='3'

[Error]
Unknown column 'stream_id' in 'field list'

You can get help by sending this infomation to us: [url]http://jcow.net[/url]

In this instance, i do have stream_id in the table but still get this error.

I have had another SQL error issue, like;
A certain column do not have a default value a number of times.

What i have done in some of the cases have been to make the column nullable and at other times set a default value for such fields. This seem to work but i still would love a perfect fix.

Would be grateful if you could help me.

Regards

170 months ago
adil (@adil)
Join date: May 9th 2010
Community posts: 202
View Profile
Send Message

hi state for me please the prevous page before this page mean

if its from dash board or blog ie what r u trying to do and your jcow version please!!!

170 months ago
Eliz zeta (@eliz)
Join date: Nov 29th 2010
Community posts: 153
View Profile
Send Message

i have the same error, no solution ¡¡

170 months ago
obi mark (@daddycool)
Join date: Dec 8th 2010
Community posts: 7
View Profile
Send Message

thanks adil for your response.

i found a work around to this problem.

i edited the jcow_forum_post table and made stream_id column auto_increment. It works fine now but i'm unsure if there is any implication for this in future. But i works fine now.

170 months ago
Jcow Master (@falcone)
Join date: Sep 2nd 2010
Community posts: 917
View Profile
Send Message

what version is this, because my jcow_forum_posts doesn't have a field called stream_id.

170 months ago
Jcow Master (@falcone)
Join date: Sep 2nd 2010
Community posts: 917
View Profile
Send Message

ok, i got it. it is version 4.3

170 months ago
obi mark (@daddycool)
Join date: Dec 8th 2010
Community posts: 7
View Profile
Send Message

yes, its version 4.3

170 months ago