?
Solved

All MySQL data not showing for query

Posted on 2015-01-26
6
Medium Priority
?
274 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
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

 

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 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

762 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