Announcement

Collapse
No announcement yet.

Database Error: New User Can't Sign Up

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error: New User Can't Sign Up

    When someone tries to sign up I get a database error. Please help... as you always do... Thanks!

    mysql error: Column count doesn't match value count at row 1

    mysql error number: 1136
    Are We Fighting?
    Am I Winning?

  • #2
    Run the repair.php file and see what it brings up.
    Email: [email protected]
    Site: Under Construction

    Comment


    • #3
      Yay! Thanks for answering so fast! This is the error from the repair.php

      Invalid SQL: CHECK TABLE access
      mysql error: You have an error in your SQL syntax near 'CHECK TABLE access' at line 1

      mysql error number: 1064
      Are We Fighting?
      Am I Winning?

      Comment


      • #4
        I am unexperienced with fixing tables so I think you should seek advice from someone else.

        ^Bump^ for someone else to reply.
        Email: [email protected]
        Site: Under Construction

        Comment


        • #5
          I did notice that with the upgrade I have two tables[?] for the my country flag hack. But when I go to PHPMyAdmin I can only see one. Could this be it? How would I delete the second table?
          Are We Fighting?
          Am I Winning?

          Comment


          • #6
            There is a setting in phpMyAdmin to drop a table.

            Use with extreme caution and make a backup first - through telnet/ssh.
            Email: [email protected]
            Site: Under Construction

            Comment


            • #7
              That error means the fields in the table / query doesn't match the number of values in the insert query.

              Have you installed any hacks (I think you have, the flag thing?), or did anything to the user table?

              This has nothing to do with repair.php, nothing to repair.
              Chen Avinadav
              Better to remain silent and be thought a fool than to speak out and remove all doubt.

              גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

              Comment


              • #8
                Good Morning, FireFly! Yep, I have the flag hack. When I updated I noticed two My_Country listed. But when I go to PHPMyAdmin I can only see one. Could this be it? How would I delete the second table? Thanks bunches!
                Are We Fighting?
                Am I Winning?

                Comment


                • #9
                  Well maybe you should seek support on the hacking site, since we don't support hacks here.

                  Seriously though, it's probably that hack.
                  Even if you do have two tables that are the same (doubt it), that's not the reason for the error.
                  Chen Avinadav
                  Better to remain silent and be thought a fool than to speak out and remove all doubt.

                  גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

                  Comment


                  • #10
                    Drat! Thanks anyway... I get confused about where to post... amoung other things!

                    Have a great day!
                    Are We Fighting?
                    Am I Winning?

                    Comment

                    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                    Working...
                    X