Solved

All MySQL data not showing for query

Posted on 2015-01-26
6
251 Views
Last Modified: 2015-01-27
Hi Everyone,
Happy Monday.

On my page http:www.socalda.org/sumeet.php I have found that some new data on one row, that works fine on my local dev server, is not showing up correctly on my hosted site.

My Dev Server is WAMP:

Wamp 2.5
Apache : 2.4.9 MySQL : 5.6.17 PHP : 5.5.12 PHPMyAdmin : 4.1.14

On my hosting site it is:

Database server

    Server: Localhost via UNIX socket
    Server type: MariaDB
    Server version: 5.5.40-MariaDB-cll-lve - MariaDB Server
    Protocol version: 10
    User: mar3a@localhost
    Server charset: UTF-8 Unicode (utf8)

Web server

    cpsrvd 11.44.2.5
    Database client version: libmysql - 5.1.73
    PHP extension: mysqli Documentation

phpMyAdmin

    Version information: 4.1.8, latest stable version: 4.3.8
    Documentation
    Wiki
    Official Homepage
    Contribute
    Get support
    List of changes

I have exported the tables on my local server, with Add DROP TABLE Statement.  I have imported all changed tables and my contact and desc for Asked & Answered meeting on the page mentioned above at 10:00 am is not showing.  

Is there some coding I am not doing for  MariaDB that is causing this problem?

Thanks in Advance.
0
Comment
Question by:dloj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 40571341
Hmmm ... some of the data are not showing.  Let's try to specify a bit more which data are missing, shall we?

Are certain records missing?  Certain fields?

Do you have the exact query that your software would be using?  If you run the query using PHPMyAdmin, do the missing data appear?

In a website like this, there are at least a couple of layers too look into when data do not display.
0
 

Author Comment

by:dloj
ID: 40571465
Thanks for the response.
"On my page http:www.socalda.org/sumeet.php I have found that some new data on one row, that works fine on my local dev server, is not showing up correctly on my hosted site."

If you go to the above page the second line under Sunday Meetings the Contact field and the Desc fields are missing data but only online.

On my dev server it works fine with a WAMP config of:
Wamp 2.5
Apache : 2.4.9 MySQL : 5.6.17 PHP : 5.5.12 PHPMyAdmin : 4.1.14

Running the query in phpmyadmin the missing data does not appear.

Data is from two fields mstr_contact.cnct_fname and mstr_feature.descr  

On the same page at http://www.socalda.org/sumeet.php other meetings for that day show the information, if it has it,  that is missing from the row in question.  

That is why I do not think it is the query itself.
0
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 40571495
OK, some fields are not populated in certain rows.  You mention field names from 2 different tables.

Most likely some fields on which you are joining do not match for those records.  A contact ID is wrong ... or something like that.

I would be breaking down the problem something like this (correcting the table & field names of course).

Select * from master_table where name = 'Radford Hall';

I note the ID on which I would join.

Select * from mstr_contact where ID = < the ID from above >;

This *could* be a problem with your code you just deployed, but more likely is just plain a data error.
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:dloj
ID: 40571580
Yes, some fields are not populated but only on one row.   Not all meetings have a contact or description.

The contact field and the description field for the Asked & Answered meeting on Sunday at www.socalda.org/summet.php are not showing their data.

So there is nothing wrong with the query, because all the other meetings on Sunday that have a contact shows the contact and the same for the description.

What do you mean by data error?  I have re-imported the tables in question several times.  

I am real curious if MariaDB might have anything to do with it as I do not have MariaDB on my local server.
0
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
ID: 40571605
I am real curious if MariaDB might have anything to do with it as I do not have MariaDB on my local server.

I doubt that, but other settings could.  Possibly ... settings about capitalization for example.  You run into different defaults as you switch from a dev server on Windows to a production server on Linux.

The queries breaking down the join to see what is failing to match should give you the answer.  But look very carefully at those results, paying attention to things as small as capitalization or whitespace differences.
0
 

Author Closing Comment

by:dloj
ID: 40572734
Thanks for pointing me the right direction and settling my mind about MariaDB.   My meeting ID needed to be changed.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AWS EC2 & RDS Instance 5 64
Using coldfusion <cfexecute> to restore mysql database 7 67
Dreamweaver code color same as CS6 or CS2015 2 35
mysql qry 1 26
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question