Having an issue with my MySQL

Discussion in 'Web Design & Coding' started by Heeter, Dec 16, 2008.

  1. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Hi all,

    I am thinking that I am having a issue with mysql.

    I do have a mysql server, and have about 9 databases that are working properly, no issues whatsoever.

    One of my other db consists of my invoicing client db. For some strange reason, I cannot generate anymore new invoices. I can generate more clients, and I can email out of the db, no problem. Looks like all is fine, except for this invoice generation issue.

    I don't know if it is mysql, or if it is my interface (web-based, php GUI)

    Wondering if anyone can give me any ideas on where to start looking.


    Thanks

    Heeter
     
  2. Dark Atheist

    Dark Atheist Moderator Political User Folding Team

    Messages:
    6,376
    Location:
    In The Void
    when you say webbased gui - you mean phpmyadmin ? or something else
     
  3. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Sorry, carpo, should of been more descriptive.........

    My invoicing system is webbased. I am wondering if there is something in the php code that is wrong, that is keeping me from adding more invoices.

    I do use phpmyadmin, but I am not experiencing any problems with it.


    Heeter
     
  4. Dark Atheist

    Dark Atheist Moderator Political User Folding Team

    Messages:
    6,376
    Location:
    In The Void
    so your saying its not the pgp gui you use? but some other php code elsewhere ?
     
  5. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    yes the php code that runs my invoicing system gui. Could be that, or could be the actual mysql db that's tied to it. I don't know.

    Heeter
     
  6. Mizzle

    Mizzle Oh, now I know...!

    Messages:
    347
    Location:
    Denmark
    Could you try to rebuild PhpMyAdmin? Not sure if that's possible for you.
     
  7. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Sorry, mizzle,

    But it's not phpmyadmin that is giving me trouble. it is my web-based invoicing system.

    Heeter
     
  8. Dark Atheist

    Dark Atheist Moderator Political User Folding Team

    Messages:
    6,376
    Location:
    In The Void
    can you add new customers using mysql from command line? new tables etc? has permissions on the db changed ?
     
  9. Mizzle

    Mizzle Oh, now I know...!

    Messages:
    347
    Location:
    Denmark
    Heeter,
    Oh okay, sorry. Ah well, best one can do is try.
     
  10. X-Istence

    X-Istence * Political User

    Messages:
    6,498
    Location:
    USA
    Heeter:

    Does the web based invoice program has some way to enable debugging so you can see if it is throwing errors somewhere? Also, check you Apache log files, they might contain information on the PHP errors.

    Other things to check, see if the table is overly full, using phpMyAdmin. Try running REPAIR `table name`; in MySQL and see if that fixes anything. If not, what web based software are you using? If it is open source I could maybe take a look.
     
  11. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    I will try the repair table, I think that it is my mysql.

    It is open source, straight up php code only.

    Heeter
     
  12. X-Istence

    X-Istence * Political User

    Messages:
    6,498
    Location:
    USA
    What is it called? The invoice app that is.
     
  13. Mizzle

    Mizzle Oh, now I know...!

    Messages:
    347
    Location:
    Denmark
    Yeah, that would probably help :)
     
  14. Geffy

    Geffy Moderator Folding Team

    Messages:
    7,805
    Location:
    United Kingdom
    how many invoices do you have? what is the size of the id field and is it signed or unsigned?
     
  15. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Here is the link:

    http://www.onlineinvoicesystem.com/index.html

    Been using for a couple of years now.

    I am trying to figure out how to repair tables using phpmyadmin. I use to have sqlyog on my windows server system, but don't have it anymore.


    Heeter
     
    binoyxj likes this.
  16. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Just noticed that they have an online forum. maybe I will join in and see if it is still up and running.

    Heeter
     
  17. Mizzle

    Mizzle Oh, now I know...!

    Messages:
    347
    Location:
    Denmark
    How about replacing the add_invoice.php file?
     
  18. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Hey, that's an idea.

    I will try that.

    Heeter
     
  19. Mizzle

    Mizzle Oh, now I know...!

    Messages:
    347
    Location:
    Denmark
    :)

    Please let us know how it turned out.
     
  20. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Hey guys,

    I changed the php files with new ones. to no effect.

    So it must be my sql tables.

    Trying to figure out how to repair tables through phpmyadmin.


    Thanks

    Heeter