Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

All MySQL data not showing for query

Posted on 2015-01-26
6
Medium Priority
?
291 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 free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
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…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

604 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