Error 28 - but...

Author: jack     03 13th, 2010 in enart.abczj.com     edit

  • ...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


  • Oops!

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


  • 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 :(


  • 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


  • 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/


  • Ouch :(

    Thanks for the quick reply though.


  • 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


  • 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?


  • 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:"


  • 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


  • 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.







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Error 28 - but... , Please add it free.

    Google Adsense Profits Mixed In With Affiliate Marketing - Google Adsense Kids Eating Healthy