Severe MySQL problems

[Yaa101]

I have a major prolem since last week...

for 1,5 years i worked with mysql,php and apache without any problems...

since i installed EZpublish i have severe problems that wont go away...
I tried everything including re-installing even win2k...

Am i missing something here?

PLEASE HELP before i throw my stuff through the window...

After re-installing win 2k, several versions of apache,mysql and php i still have this crap and i am getting realy desperate...

I realy hope others recognise my problems...

symptoms:
No granting problems or errors at all, at glance all seems well...
The only app that has some access is phpmyadmin...
Apps other then phpmyadmin fail in making a new db...
When i try to submit changes on a record in a table i get a error in phpmyadmin: ERROR MySQL returns: query is empty.
or: You have an error in your SQL syntax near 'nnnnnnnnnn' at line 1.

somehow mysql is locked and not locked and very very anoying


PLEASE!!! Help!!!

I almost get a feeling that people at MS do this somehow... not sure...

 

[Yaa101]

This Report was made using the WinMySQLAdmin 1.3 Tool

2-5-2002 17:54:40

OS Platform : Windows 2000 Service Pack 2
Machine description:
Compiler : VC++ 6.0
Architecture : i686
Total Memory : 785888 KB RAM

My.ini File

[mysqld]
basedir=E:/net/http/servers/mysql
bind-address=127.0.0.1
datadir=E:/net/http/servers/mysql/data

Server Status Values

Server Info 4.0.1-alpha-nt
Host Info localhost via TCP/IP
Client Info 3.23.36
Proto Info 10
Aborted_clients 2
Aborted_connects 4
Bytes_received 0
Bytes_sent 0
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 18
Com_change_master 0
Com_check 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_delete 0
Com_delete_multi 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_insert 0
Com_insert_select 0
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 0
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_select 4
Com_set_option 0
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_create 0
Com_show_databases 18
Com_show_fields 18
Com_show_grants 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_stat 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_processlist 3
Com_show_slave_hosts 0
Com_show_slave_stat 0
Com_show_status 190
Com_show_tables 14
Com_show_variables 12
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 0
Connections 31
Created_tmp_disk_tables 0
Created_tmp_tables 0
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 0
Handler_read_first 1
Handler_read_key 0
Handler_read_next 0
Handler_read_prev 0
Handler_read_rnd 0
Handler_read_rnd_next 14
Handler_update 0
Handler_write 0
Key_blocks_used 0
Key_read_requests 0
Key_reads 0
Key_write_requests 0
Key_writes 0
Max_used_connections 1
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 6
Open_files 12
Open_streams 0
Opened_tables 12
Questions 171
Qcache_queries_in_cache 0
Qcache_inserts 0
Qcache_hits 0
Qcache_not_cached 0
Qcache_free_memory 0
Qcache_free_blocks 0
Qcache_total_blocks 0
Rpl_status NULL
Select_full_join 0
Select_full_range_join 0
Select_range 0
Select_range_check 0
Select_scan 1
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 0
Sort_rows 0
Sort_scan 0
Table_locks_immediate 6
Table_locks_waited 0
Threads_cached 0
Threads_created 30
Threads_connected 1
Threads_running 1
Uptime 947

Variables Values

back_log 50
basedir E:\net\http\servers\mysqlbinlog_cache_size 32768
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert ON
connect_timeout 5
datadir E:\net\http\servers\mysql\datadelay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 1800
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
ft_boolean_syntax + -><()~*:&quot;&quot;&|
have_bdb NO
have_innodb NO
have_isam NO
have_raid NO
have_symlink YES
have_openssl NO
init_file
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language E:\net\http\servers\mysql\share\englishlarge_files_support ON
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_long_queries OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 1
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_bulk_insert_tree_size 8388608
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options OFF
myisam_sort_buffer_size 8388608
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file E:\net\http\servers\mysql\data\tke.pid
port 3306
protocol_version 10
record_buffer 131072
record_rnd_buffer 131072
rpl_recovery_rank 0
query_buffer_size 0
query_cache_limit 1048576
query_cache_size 0
query_cache_startup_type 1
safe_show_database OFF
server_id 0
slave_net_timeout 3600
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket MySQL
sort_buffer 2097144
sql_mode 0
table_cache 64
table_type MYISAM
thread_cache_size 0
thread_stack 65536
transaction_isolation READ-COMMITTED <- IS THIS MY PROBLEM??????
timezone W. Europe Daylight Time
tmp_table_size 33554432
tmpdir E:\WINNT\TEMPversion 4.0.1-alpha-nt
wait_timeout 28800

Last Lines from Err File

MySql: ready for connections

020502 17:37:59 MySql: Shutdown Complete

020502 17:37:59 MySql: Normal shutdown
MySql: ready for connections

020502 17:12:38 MySql: Shutdown Complete

020502 17:12:38 MySql: Normal shutdown
MySql: ready for connections

020502 17:02:55 MySql: Shutdown Complete

020502 17:02:55 MySql: Normal shutdown

 

[Yaa101]

up again...

Any proffesionals here?!?!

 

[rycamor]

I see that you are using &quot;4.0.1-alpha-nt&quot;. That is not yet a stable version of MySQL. It is not even at beta status yet; that is why it has the word -alpha- in it. If you want a good, stable version of MySQL, you should stick with the latest version in the 3.xx.xx series.

MySQL version 4 involves some major changes in features, and it is definitely not yet recommended for production use. On top of that, you are using Windows 2000 as your OS, which is not really MySQL's primary target platform. MySQL runs far better on Unix platforms than on Windows. -------------------------------------------

&quot;Now, this might cause some discomfort...&quot;
(

http://www.wired.com/news/politics/0,1283,51274,00.html)

 

[Yaa101]

Like I said...

I used many version including the last 2 as i still have them at home...

All version ran normaly before... suddenly all don't...

don't give me this instable talk...

I know it runs better on linux...

But there is something else at hand... a package cannot suddenly stop running anymore after running normaly after 1,5 years...

Bassie.

 

[gheist]

http://www.arachnoid.com/lutusp/dll_article.html

 

[Yaa101]

nice story...

But what are you trying to say?

I should compile mySQL myself? you pay for a copy of MS Visual C++? i cannot afford it... i am stuck with the binary distro...

Why do you think i use Open Source? i don't have millions to invest in fancy dancy stuff...

I explain one more time...


I tried this before (clean win2 install) and after Service Pack upgrade...
I have tried several binary versions of Apache... ones that worked before.
I use the manual binary PHP distribution followed like usual the instuctions to install with Apache... these worked as well before...
I also have tried several 3 and 4 series i still have, all binary versions...

I have no granting problems, only instability problems...
Some rows in some tables i cannot access, read or write...
It seems as if mySQL or the PHP client cannot handle certain types of info already stored before.

Example, i have data for my Vbulletin board and have no problem LIKE BEFORE importing it from the commandline.
When i try to login even it wont let the software readout even those rows that are needed to authenticate.
When i check in phpmyadmin it gives the same conclusion that nothing happens when i push the edit link to access that perticular row...
I can add a row in that same table, fill it without any problem, i can remove it again, BUT NOT THESE CERTAIN ROWS... they seem locked somehow but i never locked them or gave any order to lock them...


Please help... putting on stories like it's unstable and stories about dll corruption do NOT help at all and make me even more frustrated...

If that is what you want to say then please close this again and help the next thread...

The caps used here are not ment to shout but for emphasis...

So please if you can then help or go on and dont put things that don't help anyway...

Bassie.

 

[gheist]

i am trying to say that your new EZpublish replaced some dll recently and MySQL wont run anymore.
You can check microsoft NT4 resouce kit to download depend.exe - a dependency walker or a process explorer from sysinternals.com to find which dll you will nwwd to put in your mysql program directory

 

[Yaa101]

I am telling i am on a clean install...

whatever was replaced isn't there for at least 2 re-installments...

sorry to be so rude but please read well...

THERE SHOULD BE NO PROBLEM WITH DLL DEPENDENCIES AFTER A CLEAN INSTALL...

Am i wrong? are there midgets on my HDD nowadays to place DLL's back that i have taken off in the process of re-installing win 2k several times?

thanks for the link but it wont help me...

Please for the last time: I re-installed win 2k several times with taking all old stuff off there...
Realy there is more wrong then just a dll problem...

Bassie.

PLEASE READ ALL BEFORE YOU ANSWER THIS THREAD...

and still not shouting...

 

[gheist]

There should be no crashes in windows and fast-saves should perform in background, and you can still type while word does background printing etc etc etc - it is all well documented just like fixing system by reinstalling - so why are you asking here if you have it all written there so clear

 

[Yaa101]

Because there is something majorly wrong in 1 of the 3 processes...

I am fully aware all should work well...

It does not and i am not a win 2k engineer...

You can mail me at yaa@euronet.nl

Then i can give you the address of my phpmyadmin so you can see for yourself what should work but does not...

Also i am prepared to re-install on your instructions when needed...

I post here because i need help, not get get told things supposed to work and that i am crazy...

Bassie.

 

[gheist]

In first post you say problems started with EZPublish - then - that there should be no problems - then that 1/3 of yo is wrong - so where the truth is - out there? - you say you installed apache - was it 1.3 or 2 series ?

sorry there are no problems with your mysql - and i dont need any access to your system - so this will be of no help

 

[Yaa101]

ok i re explane...

The problems, whether or not they should be here started when i installed that...

I know from experience that a re-installment of win2k is less bothersome then to try to repair things...
And i too was in the understanding that once that happened all should be ok again but it isn't...

I re-installed both the 3.xx version and 4.xx versions of mysql and also all seems ok, i get no errors at all...
I re-installed several versions of Apache 1.3.xx, i know the 2 series simply does not yet work with PHP...
I re-installed versions 4.1.xx (even older unsafe versions) and 4.2.xx...

All 3 in several combinations of several versions look like they work, no problem importing databases from the commandline...
All PHP give a clean phpinfo(); readout on my system...
I can even access, read and write most databases, tables and rows...

However certain key tables in several databases which i import from my online linux running databases (they run even at this moment and drive my VBulletin forums) are not accessible on my win32 installation whatever i do...

It feels like sombody has switched a secret swith in 1 of the 3 programs to piss me off... And it works... i am majorly pissed off by this...



So concluding:

No granting problems, no running problems (all SEEM to run fine)...

Only some select rows in some select tables in some select databases are not acessible...


I hope i am clear this time...

Bassie.

 

[Yaa101]

Oh yes, i can give all the reports you want, the places they are installed and all ini and config files if needed to solve this...

I do not believe in instability problems when things worked fine 1,5 years in several installments and several versions of all 3 programs...

Bassie.

 

[Yaa101]

Jipeeeeeeeeeeee!!!!!!!!!


I found it after a lot of cursing... Be glad you are not my iiyama... The verbal crap you would have heard...

Ok I found it and in a way i am sad...

It was in PHP... Yes 1 setting...

This is in my php.ini:

; You should do your best to write your scripts so that they do not require
; register_globals to be on; Using form variables as globals can easily lead
; to possible security problems, if the code is not very well thought of.
register_globals = Off


Guess what...
It needs to be set on as most Authertication is written with set on, i had problems with my VBulletin, OpenBB...

Last but not least leaving it off renders phpmyadmin unpredictable...

The trouble with my MySQL server was only a symptom because of this setting...

For all others on here, don't forget to set it on...

Now i can go back to my normal stuff... lol...

Bassie.