All MySQL data not showing for query

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.
dlojAsked:
Who is Participating?
 
Daniel WilsonConnect With a Mentor Commented:
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
 
Daniel WilsonCommented:
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
 
dlojAuthor Commented:
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Daniel WilsonCommented:
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
 
dlojAuthor Commented:
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
 
dlojAuthor Commented:
Thanks for pointing me the right direction and settling my mind about MariaDB.   My meeting ID needed to be changed.
0
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.

All Courses

From novice to tech pro — start learning today.