SQL or the Code?

Quote:

Originally Posted by Drabur you use the webshop from sedrika?

Quote:

Originally Posted by xTwiLightx Check ODBC Errors in your PHP Error file (in Windows C:\Windows\Temp\php_errors.log by default). But thats only the case when the ODBC function calls used by the item sender are not error-supressed ( e.g. @[Only registered and activated users can see links. Click Here To Register...]c_exec).

Quote:

Originally Posted by pakinglalat Hi there, thank you for giving me hope by replying but "php_errors.log" is not present in the said folder. I cannot seem to find it in the "C:" drive whenever I try to search for it. I believe that I do not have any faults in the code because I did not touch anything in it.

Quote:

Originally Posted by xTwiLightx Sorry, it could be C:\Temp, not C:\Windows\Temp. It really depends how PHP is configured on your system, but mostly it was C:\Temp.

if(isset($_POST['shopBuyItem'])) {

Quote:

@odbc_exec

Quote:

odbc_exec

Quote:

Originally Posted by xTwiLightx How did you setup your website? IIS with PHP or XAMPP? We need way more details than you gave us. Maybe you should look for this one in your sites/shop.php: Code: if(isset($_POST['shopBuyItem'])) { And remove all leading @'s before your odbc_exec function calls. to This should make it possible for your site to log errors. But we really need to know where your error logs are.

	if(isset($_POST['shopBuyItem'])) {
					if( [MENTION=311501]ODB[/MENTION]c_exec($odbc_connect, $strUpdateBalance)
						AND
						 [MENTION=311501]ODB[/MENTION]c_exec($odbc_connect, '
                                INSERT INTO [' . $_CONFIG['db_databases']['web'] . '].dbo.[LOG_PURCHASES] (
                                    item,
                                    itemname,
                                    itemcount,
                                    itemcurrency,
                                    itemworth,
                                    account,
                                    datetime
                                ) VALUES (
                                    ' . cleanSqlInput($mixedSelectedItemDetailsArray['itemid']) . ',
                                    \'' . cleanSqlInput($mixedSelectedItemDetailsArray['name']) . '\',
                                    ' . cleanSqlInput($mixedSelectedItemDetailsArray['count']) . ',
                                    ' . $intGetCurrentCurrency . ',
                                    ' . cleanSqlInput($mixedSelectedItemDetailsArray[$intWorthColumnHelper]) . ',
                                    \'' . cleanSqlInput($_SESSION['user']) . '\',
                                    \''. date($_CONFIG['web_date_format']['dbDatetime']) .'\'
                                )
							')
						AND
							send_item($intCharacterID, $mixedSelectedItemDetailsArray['itemid'], $mixedSelectedItemDetailsArray['count'])
					) {
						echo createMessage($_LANG['success_item_bought'], 'success');
					}
					else {
						echo createMessage($_LANG['error_item_could_not_be_sent'], 'fail');
					}
				}

Quote:

Originally Posted by pakinglalat Hello there, sorry for the very late reply. I will be trying to do this for the php log to show up. Since I only have the errors for the apache I believe but in the apache error logs there are some php related errors and I do not see any thing regarding the cause of my problem in it. I am using XAMPP. This is the one you are talking about that I did not alter in any way: Code: if(isset($_POST['shopBuyItem'])) { if( [MENTION=311501]ODB[/MENTION]c_exec($odbc_connect, $strUpdateBalance) AND [MENTION=311501]ODB[/MENTION]c_exec($odbc_connect, ' INSERT INTO [' . $_CONFIG['db_databases']['web'] . '].dbo.[LOG_PURCHASES] ( item, itemname, itemcount, itemcurrency, itemworth, account, datetime ) VALUES ( ' . cleanSqlInput($mixedSelectedItemDetailsArray['itemid']) . ', \'' . cleanSqlInput($mixedSelectedItemDetailsArray['name']) . '\', ' . cleanSqlInput($mixedSelectedItemDetailsArray['count']) . ', ' . $intGetCurrentCurrency . ', ' . cleanSqlInput($mixedSelectedItemDetailsArray[$intWorthColumnHelper]) . ', \'' . cleanSqlInput($_SESSION['user']) . '\', \''. date($_CONFIG['web_date_format']['dbDatetime']) .'\' ) ') AND send_item($intCharacterID, $mixedSelectedItemDetailsArray['itemid'], $mixedSelectedItemDetailsArray['count']) ) { echo createMessage($_LANG['success_item_bought'], 'success'); } else { echo createMessage($_LANG['error_item_could_not_be_sent'], 'fail'); } }