Specialty Forums
Security and Virus
General Hardware
CPUs/Overclocking
Networking
Digital Photo/Video
Office Software
PC Gaming
Console Gaming
Programming
Database
Web Development
Digital Home

General Forums
Windows XP
Windows Vista
Windows 95/98
Windows Me
Windows NT
Windows 2000
Win Server 2008
Win Server 2003
Windows 3.1
Linux
PDAs
BeOS
Novell Netware
OpenVMS
Solaris
Disk Op. System
Unix
Mac
OS/2

Drivers
Driver Scan
Driver Forum

Software
Automatic Updates

BIOS Updates

My Computing.Net

Solution Center

Free IT eBook

Howtos

Site Search

Message Find

RSS Feeds

Install Guides

Data Recovery

About

Home
Reply to Message Icon Go to Main Page Icon

Site not reading from database

Original Message
Name: Chxta
Date: July 13, 2007 at 08:10:34 Pacific
Subject: Site not reading from database
OS: Ubuntu Linux 6.10
CPU/Ram: 1.7 GHz/1536MB
Model/Manufacturer: Acer Aspire 1640z
Comment:
I am administering a website, and one of the pages is not reading the database. Everything is in perfect condition from the back end, and the initial link shows all that needs to be shown. However when you click the link nothing is displayed, no images, no text.

Report Offensive Message For Removal


Response Number 1
Name: Michael J (by mjdamato)
Date: July 13, 2007 at 08:34:23 Pacific
Subject: Site not reading from database
Reply: (edit)
Well, you didn't ask a question, but I'm assuming you are seeking help in solviong your problem. But, you are not providing enough information.

What type of database?
What type of technology (PHP, ASP, etc.)?
How is the page connecting to the database (some code)?
Are you getting errors? What are they?
What debugging have you done so far and what were the results?

Michael J


Report Offensive Follow Up For Removal

Response Number 2
Name: Chxta
Date: July 13, 2007 at 08:38:26 Pacific
Subject: Site not reading from database
Reply: (edit)
PHP. No error message at all. I've checked it out from the database and everything is as I inserted it.

(http://www.thenaturalshoestore.com/index.php?m=catalogue&a=vw_prod&cat=0&sec=0&opr_oprid=909)

if you search for 'cow' it shows what you are supposed to see, but when you click on the link for more detail, nothing shows up. Every other link is working.

Thanks.


Report Offensive Follow Up For Removal

Response Number 3
Name: Don Arnett
Date: July 13, 2007 at 11:10:07 Pacific
Subject: Site not reading from database
Reply: (edit)
It appears that the info for the "cow" boot is in the database, as you can access it via other routes and if you click on "Add to Basket" the item name and price are added to the basket. Most likely the code for that link (clicking on the image of the boot on the page returned when you search for 'cow') has a typo.

You or someone will have to look into the PHP code. Hopefully there is a log file to use.


My point is, I don't think it's a database problem, but the link code or the php code that reads from the database is messed up.


Report Offensive Follow Up For Removal

Response Number 4
Name: Michael J (by mjdamato)
Date: July 13, 2007 at 16:41:43 Pacific
Subject: Site not reading from database
Reply: (edit)
Well, it appears to me that the problem is with that particular product (or some products), but not all the products.

If you do a search for "SANITA" you get that same product and many more. When I click on some of the other products, their description pages showed up fine, but that one did not. My guess would be that there is a database entry for that product, but not all the information is present.

But, there's no way for anyone to tell what the exact problem is w/o access to the database and files to debug.

Michael J


Report Offensive Follow Up For Removal

Response Number 5
Name: Chxta
Date: July 16, 2007 at 01:45:57 Pacific
Subject: Site not reading from database
Reply: (edit)
Thanks for the responses guys, I've reported the problem to the website developers.

Report Offensive Follow Up For Removal


Response Number 6
Name: Chxta
Date: July 17, 2007 at 00:57:02 Pacific
Subject: Site not reading from database
Reply: (edit)
They responded with the following:

The problem with the page was that a new fabric had been added to the system that hadn't synced up to the website. Currently we have a way for you to synchronise the character based lookup table but not the numeric lookup table (which the fabrics are in). We will look to add the ability for you to syncronise that table in the same was as you do the character table. For now we have syncronised it up manually, if there are any others that need doing please let us know.


Report Offensive Follow Up For Removal



Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Site not reading from database

Comments:

 
  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 


Data Recovery Software




Batch File- Current Date in Excel

how to setup call of duty to joytok

WindowsME / HotMail Problem

Corrupt memory

Convert fat32 to Ntfs


The information on Computing.Net is the opinions of its users. Such opinions may not be accurate and they are to be used at your own risk. Computing.Net cannot verify the validity of the statements made on this site. Computing.Net and Computing.Net, LLC hereby disclaim all responsibility and liability for the content of Computing.Net and its accuracy.
PLEASE READ THE FULL DISCLAIMER AND LEGAL TERMS BY CLICKING HERE

All content ©1996-2007 Computing.Net, LLC