Error on aplying pakages "Wrong value type sent to the database. Array of intege

Started by Chemo, September 22, 2008, 02:26:23 AM

Previous topic - Next topic

Chemo

I have this error when I try to install new paqueges, I did an upgrade to Beta 4 and I'm not able to upload any extras.

"Wrong value type sent to the database. Array of integers expected"

I use MySQL 4.0

Thanks for your help!.

[email protected]
www.rasconphotography.com
User: test
password: 123456789

Chemo

This is the info in my SQL

MySQL Statistics
MySQL 4.0.x
Connections per second:  5.6254 
Kilobytes received per second:  0.0855 
Kilobytes sent per second:  0.0925 
Queries per second:  123.7176 
Percentage of slow queries:  0.0001 
Opened vs. Open tables:
(table_cache)  16176980.2656 (should be <= 80)
 
Table cache usage:
(table_cache)  1 (should be >= 0.5 and <= 0.9) 
Key buffer read hit rate:
(key_buffer_size)  0.0384 (should be <= 0.01) 

Key buffer write hit rate:
(key_buffer_size)  0.3387 (should be <= 0.5) 
Thread cache hit rate:
(thread_cache_size)  3942.4537 (should be >= 30 ) 
Thread cache usage:
(thread_cache_size)  0.5 (should be >= 0.7 and <= 0.9)
 
Temporary table disk usage:
(tmp_table_size)  0.2539 (should be <= 0.5) 
Sort merge pass rate:
(sort_buffer)  0.0001 (should be <= 0.001) 
Query cache enabled:
(query_cache_type)  1 (should be >= 1 and <= 1) 
Query cache miss rate:
(query_cache_limit)  0.3609 (should be <= 0.5) 
Query cache prune rate:
(query_cache_size)  0.4451 (should be <= 0.05) 

Theni

Simple fix is simple.

OPen up phpmyadmin or w.e. and find '{your_smf_prefix}_settings' -> 'knownThemes'

I bet its something like ',5'.

Change it to '0,5'

Rumbaar

Does this occur for all new mods you try to install via Package manager?  What is the mod you've tried?  Also are you sure it's 100% compatible with 2.x?

Do you get any additional errors in your error logs?
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

edi67

Quote from: Theni on September 22, 2008, 11:03:26 AM
Simple fix is simple.

OPen up phpmyadmin or w.e. and find '{your_smf_prefix}_settings' -> 'knownThemes'

I bet its something like ',5'.

Change it to '0,5'
i had same errors using one game with smf arcade and tryng to save score

you are sure about this modifications ?

my value inside that table are: 1,2,3,4,5,6,7

i must change it ?
CrazyZone - My SMF Forum


From the difficult the hardening of the man you can see

NoriSilverrage

No, I wouldn't recommend doing that, or if you do save your values first.

The fix for me was to check the DB field it was referencing (buddy list) and check the value in there, mine had extra single quotes which was what was screwing it up. Thankfully my forum is small and so manually changing that wasn't hard.

Advertisement: