Guest Posted February 28, 2006 Share Posted February 28, 2006 has anyone gotten to that dreaded -21465456 something or another number? (be it by legit orders or a combination of orders/testing)? what do you do when you reach it? i realize that if anyone had hit that number legitimately, they probably have enough money to hire someone to fix the problem, but i'm curious as to what preperations need to take place so the site doesn't go down? can you reset the customer or product ids without the site breaking? Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2006 Share Posted March 1, 2006 sometimes may happen if the sql query doesn't do the filtering right like if you force the query to store -1 on the autoindex column. Or there is a security hole for cross-site scripting. You should be able to get rid of it by changing the next autoindex field with phpmyadmin. The correct solution though will be to locate the code that causes this and fix it. So before correcting the problem take a backup of the dbase so you can examine it. Under normal circumastances shouldn't happen. Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2006 Share Posted March 1, 2006 i've had that happen to one of my sites before, you helped me fix it :) but i mean; doesn't mysql have a set number that it will basically close off the database once the id number has been reached? i think i've seen a post about this here a few months ago, but i can't find it what does one do when their products or customers field becomes full? or is there no such thing and i simply misinterpreted something? Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2006 Share Posted March 1, 2006 you should setup the column data type to be large enough to hold the maximum possible number the table may reach. Other than that you could add some extra checking code right after you update sql tables to retrieve the highest id stored. But the database can be updated otherwise from external factors in which case I do not know of an easy solution. Even say if you have a dedicated server and you modify the mysql table engine source code to handle the autoincrement functions, a script can still alter/corrupt an sql table. Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2006 Share Posted March 1, 2006 i'm using the default osc installation with several contributions.. so far i have not reached that number, but will the shop be crippled when/if i do? what could the extra coding achieve if the database is full? not sure what you mean here about this: Even say if you have a dedicated server and you modify the mysql table engine source code to handle the autoincrement functions, a script can still alter/corrupt an sql table. Link to comment Share on other sites More sharing options...
BrettLefty Posted March 1, 2006 Share Posted March 1, 2006 i've had that happen to one of my sites before, you helped me fix it :) but i mean; doesn't mysql have a set number that it will basically close off the database once the id number has been reached? i think i've seen a post about this here a few months ago, but i can't find it what does one do when their products or customers field becomes full? or is there no such thing and i simply misinterpreted something? I think you mean when you have enough records, the database only has the ability to become so large. I dont know how this works but it would seem like a database can be as big as size permits. I dont know what you would be saving on an online database that could possibly get that big. It would be good business practice to export all orders etc. from the database every month to keep size down and to ensure that you have a secure backup on some secondary computer. If you have that many items id like to see your site as its probably one of the most amazing sites out there... The only other reason i could see for a particular table growing that big is maybe the customers table if your selling to a LOT of customers. check out this link> http://www.webmasterworld.com/forum112/333.htm i dont know which one mysql uses but> http://www.linuxplanet.com/linuxplanet/tutorials/6034/7/ also you might look at> http://mirror.tomato.it/mysql/doc/refman/5...imitations.html I think a mysql forum would be a better place to ask for help on this matter. Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2006 Share Posted March 1, 2006 If you have that many items id like to see your site as its probably one of the most amazing sites out there... in my first post i stated i haven't gotten that far yet, but thanks for the links :) Link to comment Share on other sites More sharing options...
Guest Posted March 2, 2006 Share Posted March 2, 2006 i'm using the default osc installation with several contributions.. so far i have not reached that number, but will the shop be crippled when/if i do? what could the extra coding achieve if the database is full? not sure what you mean here about this: Even say if you have a dedicated server and you modify the mysql table engine source code to handle the autoincrement functions, a script can still alter/corrupt an sql table. you can download the source code for the mysql engine. So you could customize it. As of the extra coding it could test if the autoincrement ID is out of range and act accordingly. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.