[solved]sql_mode

Problems with the Windows version of XAMPP, questions, comments, and anything related.

[solved]sql_mode

Postby its me » 31. October 2011 15:50

hello

windows server 2008 xampp 1.7.1 (php 5.2.9 & mysql 5.1.33

I need to sit this sql_mode to not strict, i am not sure even how to check it on xampp version 1.7.1 !! i have read on the internet many articles like this:
http://digitalmemo.neobie.net/2009/03/0 ... -sql-mode/

but they speak about files in xampp which are not avaialable in my version of xampp ??!

any help for this please?
its me
 
Posts: 61
Joined: 03. October 2011 09:45
Operating System: Windows server 2008 SP1 R2

Re: sql_mode

Postby Altrea » 31. October 2011 19:18

hello again :D

its me wrote:I need to sit this sql_mode to not strict

Should i ask, why you need to set this? mh... maybe not :)
But remember just one thing (from programmer to programmer): Every change away from the default configuration you made must (certainly) be done again if you update to a newer XAMPP version.

its me wrote:i have read on the internet many articles like this:
http://digitalmemo.neobie.net/2009/03/0 ... -sql-mode/

but they speak about files in xampp which are not avaialable in my version of xampp ??!

Your XAMPP MySQL should have at least one my.cnf or my.ini file. Otherwise it wouldn't start at all.
@XAMPP 1.7.7 it is in the \xampp\mysql\bin folder, don't know where it is @XAMPP 1.7.1
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: sql_mode

Postby hackattack142 » 31. October 2011 22:25

I might also suggest you give the server documentation a look first as well when you run into a problem: http://dev.mysql.com/doc/refman/5.1/en/ ... modes.html
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: sql_mode

Postby its me » 01. November 2011 05:30

Hi Altrea,
you are right, i will observe that.
actually i am trying to test an application which is not working and after tracing the code developers they said it must be not strict, so i wanted to know how to do that in xampp 1.7.1 -- - - -but!? yet i couldn't find that! although i have my.ini but is that idea he provides in the website correct???
as it is not applied to my version of my.ini so i think it is already (not strict) !? how i can make sure? could you please explain it more?

hey hackattack142, thanks for your addition, actually i read that, but not sure that xampp applies this, therefore u might find some changes in xampp like they put some files in other places in the compilation, then you will be doing changes in somewhere else and notice you do unaffected changes :) so ask these good guys here to lead you to the point without messing your distribution ;) :)

please help
its me
 
Posts: 61
Joined: 03. October 2011 09:45
Operating System: Windows server 2008 SP1 R2

Re: sql_mode

Postby Altrea » 01. November 2011 08:46

its me wrote:actually i am trying to test an application which is not working and after tracing the code developers they said it must be not strict, so i wanted to know how to do that in xampp 1.7.1 -- - - -but!? yet i couldn't find that! although i have my.ini but is that idea he provides in the website correct???

as it is not applied to my version of my.ini so i think it is already (not strict) !? how i can make sure? could you please explain it more?

You should first check if your MySQL is running in any strict mode. You can easily check that in phpmyadmin => variables tab. There should be a sql mode variable. If it is empty, no strict mode is setted.
(Of cause there are other ways to check that too. The description you posted. The SQL command "SELECT @@globals.sql_mode;" can be executed in phpmyadmins SQL Tab, or in themysql command line interface).
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: sql_mode

Postby Sharley » 01. November 2011 08:53

In 1.7.1 the my.ini file is in the \xampp\mysql\bin folder.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: sql_mode

Postby its me » 01. November 2011 20:33

okay! i got the my.ini guys, it says the following: so am i running sql mode strict or not strict?

Code: Select all
port= 3306
socket= "C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"


also in phpadmin looks is written "nothing" in the field sql_mode ? just an empty field (in variables tab) as you instructed thankfully, is that strict or not strict guys? i am confused, i am not that much experienced in this stuff, please help
its me
 
Posts: 61
Joined: 03. October 2011 09:45
Operating System: Windows server 2008 SP1 R2

Re: sql_mode

Postby Altrea » 01. November 2011 21:15

You are not running in any MySQL strict modes
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: sql_mode

Postby its me » 01. November 2011 21:19

oh! God, help please, how to make it not strict??????????
its me
 
Posts: 61
Joined: 03. October 2011 09:45
Operating System: Windows server 2008 SP1 R2

Re: sql_mode

Postby Altrea » 01. November 2011 21:27

Let me speak MUCH more clearly:

IT IS NOT STRICT, RIGHT NOW!
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: sql_mode

Postby its me » 01. November 2011 21:29

ooops, then i am having another issue with this crazy application,
can you please have a look at this?
viewtopic.php?f=16&t=48793
its me
 
Posts: 61
Joined: 03. October 2011 09:45
Operating System: Windows server 2008 SP1 R2

Re: sql_mode

Postby Altrea » 01. November 2011 21:35

so, i can close here
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 140 guests