Jump to content


Photo

Database Editor not showing new entries?


  • Please log in to reply
8 replies to this topic

#1 jca13

jca13
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 12 September 2006 - 08:53 PM

I currently use phpMyAdmin as a web-based mySQL database editor.

However, the entries that phpMyAdmin shows as the database having are 2 weeks out of date - the database, according to the editor has not been updated for 2 weeks.

The website is working fine though - recalling entries from the entire database including the past 2 weeks, and happily adding new ones on request.

Anybody have any idea as to what could be wrong?

Thanks!

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 12 September 2006 - 09:05 PM

Maybe the system date is wrong? Check the logs.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 jca13

jca13
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 12 September 2006 - 09:16 PM

Maybe the system date is wrong? Check the logs.


No, the records from 2 weeks ago in the database editor are actually content from two weeks ago! The latest ones shown are well out of date.

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 12 September 2006 - 09:34 PM

But the website is pulling the recent content? I'm confused.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 jca13

jca13
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 15 September 2006 - 01:44 PM

But the website is pulling the recent content? I'm confused.


Yes, the website is pulling all content, since the database editor stopped recording entries and those before.

#6 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 September 2006 - 03:24 PM

I'm still confused... the "editor" doesn't know what's new and what isn't.  If the data isn't there, then the website shouldn't be able to find it either.  Please clarify.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#7 jca13

jca13
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 15 September 2006 - 04:34 PM

I'm still confused... the "editor" doesn't know what's new and what isn't.  If the data isn't there, then the website shouldn't be able to find it either.  Please clarify.


The website seems to have a fully working and complete database with which to draw and enter information into - however, the database editor I'm using (phpMyAdmin) simply stopped recording new entries several weeks back, and any changes to information in the database editor is not reflected by the website...

#8 Zane

Zane
  • Administrators
  • Advanced Member
  • 4,134 posts

Posted 15 September 2006 - 05:33 PM

perhaps you changed a setting in your MySQL server that phpmyadmin doesn't know about...
like maybe the port number or something.
Go check your Server config
and your phpmyadmin conifg file
and look for some differences

btn_donate_SM.gif Want to thank me? Contribute to my PayPal piggy-bank
 

172938.png

#9 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 September 2006 - 05:43 PM

Agreed... sounds like the website & PHPMyAdmin are talking to 2 different databases.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users