Solved

All MySQL data not showing for query

Posted on 2015-01-26
6
264 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
Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

717 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