MySQL teema

« previous entry | next entry »
Jun. 21., 2006 | 10:43 am
posted by: anne in pajautaa

Nopirkaam PhotoPost forumu pa 100$. Jamais tagad neinstaleejas jo redz, sukas nebija pateikushi, ka MySQL 5+ zhagojaas pie atsevishkiem kverijiem. Ir workaround, no kaa, protams, neko nesaprotu--

MySQL 5.0 and higher have a strict mode that is currenty incompatible
with a number of queries in PhotoPost products. The Windows Installer
from MySQL.com enables this strict mode by default.

In Layman's terms MySQL in strict mode can not allow query inserts
with null values to be entered.

Workaround
There are several workarounds

1. Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"
2. Start MySQL with the option --sql-mode="MYSQL40"
3. Execute the query SET GLOBAL sql_mode='MYSQL40'

MySQL needs to be restarted before changes in my.ini have an effect.
My.ini can be found in the MySQL installation directory or the Windows
directory, depending on your configuration



Vai man kaa parastam mirstiigam cilveekam ir pieeja shitaas mineetaas 3 rindinjas paveikt? Serveris saav kaut kur taalu amerikaa, ir webAdmin panelis, kuraa mySQL konfiguracijas protams nav un phpMyAdmin, ar kaut limiteetaam iepeejaam. Vai shite laiks griezties pie mega superadminiem?

# | jā, ir doma! | Add to Memories


Comments {2}

from: anonīmiķis
date: Jun. 21., 2006 - 10:53 am
#

Neko tu, protams, nevari. Nav pieejas /etc/my.cnf failam, un mainīt viņi kaut ko diez vai gribēs.

Atbildēt | Diskusija


watt

from: [info]watt
date: Jun. 21., 2006 - 12:08 pm
#

nu virzienā par SET GLOBAL var rakt! (lai tie produkta autori sīkāk izstāsta kur tas SET GLOBAL" ir jāiebaksta.)

Atbildēt | Iepriekšējais