MySQL :: #1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key
When you get a message like that it might mean you have no primary key defined. As in my case I created a table as SELECT from another table and tried to set auto increment on its id column.Just run the following:
ALTER your_table DROP PRIMARY KEY, ADD PRIMARY KEY ('some_table_column');
It should do the trick...
| [ 0 trackbacks ] | permalink | related link
I am still not that sure what caused persistent crashes of my Dell notebook.
Files were getting randomly corrupted. Sometimes they were recovered by check disk utility, sometimes they we gone for good.
One sunny day it went pretty bad and all that appeared was a blue screen on boot.
"STOP: 0x00000024(0x00190203,0x82FE51C8,0xC0000102,0x00000000)"
It was obvious that it was the problem with the hard drive. Some tools I ran couldn't see any partitions and displayed existing format as RAW.
After trying a few things I managed to save pretty much all data minus some files here and there which were corrupted too baldy.
Here is what I did:
- Using your windows installation CD get to Windows Recovery Console.
Here you can find some info on how to get there and how to use it: http://support.microsoft.com/kb/314058
You can get Windows distribution from Torrent. You won't need an activation key so pretty much any Windows Installation will do.
Once you are in Windows Recovery Console Prompt run the check disk utility as: chkdsk /r
Few hours of waiting and hopefully it will do the job.
You can try to boot windows again. If you are lucky and none of system files were corrupted, you'll be able to use your laptop again.
In my case windows was hopelessly screwed and here a solution to go around that:
- Download Bart's Preinstalled Environment (BartPE) This is a very useful tool which saved me more than one time during last several years.
Follow instructions from that site on how to create bootable CD
- Attach external drive via USB to your machine.
- Boot your computer from BartPE.
- Launch BartPE with A43 File Manager and make sure you can see your harddrive there with all its partitions and data.
- Make sure you can see your external USB HD there too.
- Copy all your data to the external hard drive.
- Donate a few bucks to the PE Builder creator.
- Frolic!
Well, if that scenario didn't work and your hard drive is seriously damaged you might try some other tools that can resurrect the data.
I tried to use a commercial app Uneraser. It might help, I saw people praising it in forums.
Honestly, I had rather unpleasant experience. I created bootable CD and it kept hanging and initially I blamed it on limitations of the Demo version. Buying a license didn't change anything. My message to the tech support was "politely" ignored....
Still, when disaster strikes, it is better to try all available solutions...
Good luck.
| [ 0 trackbacks ] | permalink | related link
This is a problem that is caused by some sort of issues in Windows registry. My guess that is can be caused by some missing DLLs after applications uninstalled or deleted.
In my case the problem was fixed after I cleaned up Startup programs with Autoruns utility from Sysinternals.
Just remove those entries that say File not found.
| [ 0 trackbacks ] | permalink | related link
It happened to me number of times... I start Microsoft Money as usual and it informs me that my password is incorrect. Several times I followed my natural reaction and used "Forgot Password" feature. However, my password was right and I actually knew I didn't change it.
The actual reason was some problem on the server. If you try connecting without using online services it will let you in just fine.
When your login fails and you know nobody changed it. Just give it about an hour or so.
Most probably everything will get fixed on its own.
Do not attempt to change your password since you may run into different problems if your passwords mismatch locally and on the MS Money server.
| [ 0 trackbacks ] | permalink | related link
Here is a good site that can help your search for popular Web 2.0 fonts.
Update:
One more site with free quiality fonts.
| [ 0 trackbacks ] | permalink | related link
Back Next
Avatar
