Error 28 - but...

[Martin CX]

...please forgive my ignorance, if it means there is no more room on my partition, how come there is no problem with making new posts and such?

Could it have something to do with these errors (the first reported):

Invalid SQL: INSERT INTO userfield (userid) VALUES ()
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Saturday 22nd of December 2001 05:40:21 PM
Script: ../register.php
Referer: ../register.php

Merry Christmas BTW :)

[edited in: The error 28s looks like this:

Invalid SQL: SELECT user.userid,username,usergroupid,birthday,email,pa rentemail,coppauser,homepage,icq,aim,yahoo,signatu re,usertitle,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastpost) AS lastpost,posts,ipaddress,userfield.* FROM user,userfield WHERE 1=1 AND userfield.userid=user.userid ORDER BY username LIMIT 0,99999999 my comment: this value varies - sometimes it's 30 or 300
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Sunday 23rd of December 2001 04:48:53 PM
Script: .../admin/user.php?s=...&action=find
Referer:

- - -

Invalid SQL: SELECT postid,pagetext,post.dateline,userid,thread.title as title,thread.forumid as forumid,forum.title as forumtitle FROM post,thread,forum WHERE thread.threadid=post.threadid AND thread.forumid=forum.forumid AND post.visible=0 AND (1=0 OR thread.forumid=16) ORDER BY dateline
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Sunday 23rd of December 2001 04:02:02 AM
Script: .../mod/moderate.php?s=&action=posts
Referer: .../mod/index.php?s=&loc=moderate.php?s=%26action=posts

[eva2000]

i'd close your forum right now and ask your web host since you could be posting corrupted threads when there's no space left on the drive's partition

[Martin CX]

Ouch :(

Thanks for the quick reply though.

[Martin CX]

OK. The problem wasn't a lack of memory. I've got several hundreds of MB free on my server.

So... what is it then?

I've run repair.php and it OKs everything.

As stated the problem manifests itself when

- I'm searching the user database. (But not when I list the users in a usergroup(?!))

- When I try to register a new member. When I fill in the information needed and press submit I am given an error message. However, the new member is show on the "Welcome to our newest member, XXX" and is given a user profile which is editable. BUT the new member doesn't receive a confirmation e-mail (yet, I have no problems e-mailing the user via the vBulletin forms), and even though the "Users awaiting e-mail confirmation"-usergroup shows an addition, the new user isn't listed, when I try to 'list all users', in this fashion.

Very complicated.

[eva2000]

no one said lack of memory error 28 is lack of disk space in the mysql partition of your server... something only your web host can resolve i'm afraid :(

[Martin CX]

Oops!

Sorry. I said 'memory', but I meant disk space... my host claims there are loads and loads of free disk space.

[eva2000]

Originally posted by Martin CX
Oops!

Sorry. I said 'memory', but I meant disk space... my host claims there are loads and loads of free disk space. well they may have lots of space on the /home partition but what about where mysql is located ? i.e. /var/lib/mysql etc

install this script and post the url http://phpsysinfo.sourceforge.net/

[Martin CX]

Thanks for all the support eva2000, I really do appreciate it. Happy New Year, BTW, :)

This is the data I'm given:

System vital
Kernel Version: 2.4.9-6
Uptime: 25 days 1 hours 21 minutes
Current Users: 4
Load Averages: 0.13 0.14 0.10

Network Usage
Device, Received, Sent, Err/Drop

lo, 48.35 MB, 48.35 MB, 0/0
eth0, 2.41 GB, 3.76 GB, 0/0
eth1, 0.00 KB, 0.00 KB, 0/0

Hardware Information
Processors: 1
Model: Intel(R) Pentium(R) III CPU family 1133MHz
Chip MHz: 1130.54 MHz
Cache Size: 512 KB
System Bogomips: 2254.43
PCI Devices: ATI Technologies Inc Rage XL, ServerWorks OSB4 IDE Controller, BROADCOM Corporation Tigon3, Dell Computer Corporation PowerEdge Expandable RAID Controller 3/Di, Intel Corporation 82557 [Ethernet Pro 100], PCI device 9005:00c5 (Adaptec), Adaptec 7899P
IDE Devices: hda: SAMSUNG CD-ROM SN-124
SCSI Devices: DELL PERCRAID RAID5 ( Direct-Access ), DELL PERCRAID RAID5 ( Direct-Access ),
DELL PERCRAID Volume ( Direct-Access )

Memory Usage
Type, Percent Capacity, Free, Used, Size

Physical Memory, 36%, 318.65 MB, 182.06 MB, 500.71 MB
Disk Swap, 18%, 419.31 MB, 90.53 MB, 509.84 MB

Mounted Filesystems
Mount, Type, Partition, Percent Capacity, Free, Used, Size

/, ext2, /dev/sda2, 95%, 0.00 KB, 1.06 GB, 1.12 GB
/boot, ext2, /dev/sda3, 15%, 48.38 MB, 9.24 MB, 60.76 MB
/home, ext2, /dev/sdb2, 44%, 14.02 GB, 12.03 GB, 27.45 GB
/usr, ext2, /dev/sda6, 46%, 1.08 GB, 1.03 GB, 2.22 GB
/var, ext2, /dev/sdb1, 50%, 909.20 MB, 1003.58 MB, 1.97 GB
/mnt/backup, ext2, /dev/sdc1, 58%, 6.23 GB, 9.60 GB, 16.68 GB

Totals : 50%, 22.26 GB, 24.72 GB, 49.49 GB

[eva2000]

Originally posted by Martin CX

- When I try to register a new member. When I fill in the information needed and press submit I am given an error message. However, the new member is show on the "Welcome to our newest member, XXX" and is given a user profile which is editable. BUT the new member doesn't receive a confirmation e-mail (yet, I have no problems e-mailing the user via the vBulletin forms), and even though the "Users awaiting e-mail confirmation"-usergroup shows an addition, the new user isn't listed, when I try to 'list all users', in this fashion.

Very complicated. what's the exact error message ??? and you paste the error here

[Martin CX]

When I try to register, I'm given the standard error screen ("there seems to be an error with the database yaddayaddayadda... a mail has been sent to our technical staff") and I'm sent an email with the following:

"Invalid SQL: INSERT INTO userfield (userid) VALUES ()
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Saturday 22nd of December 2001 05:40:21 PM
Script: ../register.php
Referer: ../register.php"

When I try to search for a user I'm given this error message:

"Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: SELECT user.userid,username,usergroupid,birthday,email,pa rentemail,coppauser,homepage,icq,aim,yahoo,signatu re,usertitle,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastpost) AS lastpost,posts,ipaddress,userfield.* FROM user,userfield WHERE 1=1 AND INSTR(LCASE(username),'string')>0 AND userfield.userid=user.userid ORDER BY username LIMIT 0,300
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Monday 31st of December 2001 02:53:27 PM
Script: .../admin/user.php
Referer:"

[Martin CX]

Now, somehow I've resolved the problems and the 'error 28's encountered when I tried to search the member database.

I still can't register new members, however. BUT I've realized something I should have realized way back, when I get the error message transcribed in my post above this final part of it reads thus:

Script: .../forums/forums/register.php
Referer: .../forums/register.php

Somehow an extra "forums/" have sneaked into the script. Any good suggestions where I should look for this?