?
avatar rbsl-mohit
rbsl-mohit
31 Dec 2014

default values are not in proper format.

function used to get values : getTableColumns

uses the following query :
'SELECT column_name as Field, data_type as Type, is_nullable as \'Null\', column_default as \'Default\'' . ' FROM information_schema.columns WHERE table_name = ' . $this->quote($table_temp)

it has the default values as follows :

4 =>
object(stdClass)[18]
public 'Field' => string 'core_params' (length=11)
public 'Type' => string 'text' (length=4)
public 'Null' => string 'YES' (length=3)
public 'Default' => string '(NULL)' (length=6)
5 =>
object(stdClass)[117]
public 'Field' => string 'app_params' (length=10)
public 'Type' => string 'text' (length=4)
public 'Null' => string 'YES' (length=3)
public 'Default' => string '(NULL)' (length=6)
6 =>
object(stdClass)[118]
public 'Field' => string 'ordering' (length=8)
public 'Type' => string 'int' (length=3)
public 'Null' => string 'NO' (length=2)
public 'Default' => string '((0))' (length=5)
7 =>
object(stdClass)[119]
public 'Field' => string 'published' (length=9)
public 'Type' => string 'tinyint' (length=7)
public 'Null' => string 'NO' (length=2)
public 'Default' => string '((0))' (length=5)

So when inserting values it insert the not available vlaues with these defualt values so following issue occurs :

22018 [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the varchar value '((0))' to data type tinyint.SQL=INSERT INTO joomla_xyx VALUES ('1','','644','yxz','0','Configuration Updated','127.0.0.1','2014-12-31 12:02:16','','((0))','','','ac50ef3ed6e12b029c88cf9eea97b482')

avatar rbsl-mohit rbsl-mohit - open - 31 Dec 2014
avatar jissues-bot jissues-bot - change - 31 Dec 2014
Labels Added: ?
avatar zero-24 zero-24 - change - 31 Dec 2014
Category MS SQL
avatar brianteeman
brianteeman - comment - 31 Dec 2014

Can you please test the current staging branch as there have been many updates and fixes to the SQL to address issues like this.

You can download staging by clicking here


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/5572.
avatar brianteeman brianteeman - change - 31 Dec 2014
Status New Information Required
avatar rbsl-mohit
rbsl-mohit - comment - 2 Jan 2015

Hi,

Sorry but i didn't get you.

It may help, Please look at the screen shot of the system information of the Joomla kit that i am using.

screenshot_180

avatar brianteeman
brianteeman - comment - 26 Jan 2015

Sorry I missed your reply.

This should have been fixed in the upcoming Joomla 3.4

If you download the latest development version and install that (not on a live site) and test it again it will really help. If the problem has gone please post here and we can close it. If the problem still exists please post here and the bug can be looked at.

https://github.com/joomla/joomla-cms/archive/staging.zip


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/5572.
avatar brianteeman
brianteeman - comment - 10 Mar 2015

After almost two months without response i am closing this issue (it can always be reopened if the question is answered)


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/5572.
avatar brianteeman brianteeman - change - 10 Mar 2015
Status Information Required Closed
Closed_Date 0000-00-00 00:00:00 2015-03-10 23:51:56
Closed_By brianteeman
avatar brianteeman brianteeman - change - 10 Mar 2015
Closed_Date 2015-03-10 23:51:56 2015-03-10 23:51:57
avatar brianteeman brianteeman - close - 10 Mar 2015

Add a Comment

Login with GitHub to post a comment