I installed jcow at remote server, it is working. However, I encountered many problems while installed locally. Many are due to "null" value in the table.

I am also aware '$testing=1' at the install.php but I did not see it is further used in the code. In addtion, is_local at /my/config.php is not used. What this variable for?

Thanks in advance.

1. upgrade your local database.
2. use newest version.

I downloaded 3.30 and it is a brandnew installation. Any other things to consider? Thanks

The thing I don't understand is:

1. data.sql does not define default values for many fields
2. the insert only provides some of them

Why the insert is working at hosting server but not my local server?

For example, a stream publish only provides (uid,message,created). it worked at hosting server but not my local server.

Many similar problems.

Is this because hosting server using a 'non-strict' sql mode which allows (or auto fill) null values?

I am frustrated no people from jcow team to answer questions.

install at wamp server it will work fine ... 2.0c I'm using at my windows 7 (home) windows vista (work) nothing is gone wrong exept for changing php to accept short tags !!! I think in linux if u use Linux php apache server it will work fine I installed a copy to my friend in UBUNTU 4 weeks ago to his local company it works very fine !!! so specify ur problem so we can help!!!!

thanks adil. My question is very simple.

1. I installed at my linux server at datacenter, it works.
2. I installed locally, it did not work
3. I FTP back the code from server, and compare them. Only a few configuration data different, mainly at /my/config.php
4. I am sure the code itself at local server is fine.

And I check the other file, the data.sql at /install directory which is read to create the table does not provide default values for many fields. For example, Points at jcow_accounts, wall_id at jcow_streams.

Problem #1:
When a new user registered, the insert is not working at local server because it does not provide the value for Points, for example, (it does not provide values for other fields either).

Problem #2:
When I submit "what is in your mind" with the admin account, I got an error "wall_id" does not have a default value. That is because what I said, the wall_id at jcow_streams does not have the default value for this field and when a 'status' is submitted (streampublish), it does not provide wall_id.

Therefore, why these operations are working at the hosting server?

And could any JCOW team people point out why we don't have default values at data.sql? Any specific reason.

In other words, my questions are very specific:

1. You download community version 3.3.0, unzip and check data.sql under /install. You see many fields defined as NOT NULL but without a default value

2. When INSERT to these tables, many times just a few fields have values provided. The INSERT would fail.

Example 1, register a new user at homepage, if you trace the code, you see no wall_id, no Points ect are provided at insert therefore it fails.

Example 2, use admin account to submit "what is in your mind"? Only (uid,message,created) are provided at INSERT, other fields are not and they do not have default values. That makes insert fails.

Or very basic or simple, why we don't have default values for NOT NULL fields at data.sql. Is there a specific reason?

you gave the answer already yourself i think. locally you are using the strict sql mode.

i have a local test board running under XAMPP and jcow works fine with the only alteration needed the allow short tags like Adil says.

I created a blank database and ran the install script locally, then once that is done go to phpmyadmin and drop all tables and import a copy of the db from my live online site.

i did a test, and i put my xammp server in strict mode and i got errors. Every not null field should have a default value.

thanks for all of you sharing. I guess we have to use non strict mode because we can not provide default for some fields (text/bolb).