• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 639
  • Last Modified:

Joomla assigns ID=0 to all new articles i create

So i had a joomla 1.5 site and created a new joomla 1.6 site. I merged the old 1.5 jos_content table to the new 1.6 one and uploaded it to the new site. I now have all my old articles like I want but since then, everytime i try to create a new article it assigns it with an ID=0. How can i reset this to start adding to where the new jos_content table ends?
  • 3
2 Solutions
Kevin CrossChief Technology OfficerCommented:
So this is an AUTO_NUMBER field? If so, you can try seeding it to new starting point. i.e., if your old jos_content ended at 999, you can set AUTO_NUMBER = 1000.


Open in new window

Kevin CrossChief Technology OfficerCommented:
javajamminmanAuthor Commented:
Thanks guys. I actually found the same answer you guys just posted.


I imported via excel and forgot that it did not set the auto increment. A minor overlook that caused me a big headache. thanks
Kevin CrossChief Technology OfficerCommented:
Glad it is working for you now.
Best regards and happy coding,

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now