# Mysql upgrade and weird problems

**URL:** <https://forum.xojo.com/t/mysql-upgrade-and-weird-problems/28312>\
**Category:** Databases\
**Created:** [November 27, 2015, 6:58am UTC](https://forum.xojo.com/t/mysql-upgrade-and-weird-problems/28312 "2015-11-27T06:58:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio\_cocco](https://forum.xojo.com/letter_avatar_proxy/v4/letter/a/8c91f0/32.png) [@antonio\_cocco](https://forum.xojo.com/u/antonio_cocco)\
**Post date:** [November 27, 2015, 6:58am UTC](https://forum.xojo.com/t/mysql-upgrade-and-weird-problems/28312/1 "2015-11-27T06:58:02Z")

</div>

Hi all,  
i was using mysql community server version 5.1.4; i decided to upgrade to version 5.7.9 and now i am facing few problems.  
The major is the following:  
on certain tables xojo is returning only one row, no matter how many there are in table.  
for example the original query is returning 686 rows when used in Sequel Pro, just one with xojo  
even “select table.\* from table” returns one row while pro sequel returns the whole 686 set.

tried various versions of the mysqlcommunity server plugin and i am using the same account in xojo and sequel pro.

Before rolling back i wish i could try something else.  
Any help will be greatly appreciated.

Thank you

Antonio

---

<div class="post-metadata">

**Author:** ![Greg\_O\_Lone](https://forum.xojo.com/user_avatar/forum.xojo.com/greg_o_lone/32/49_2.png) [@Greg\_O\_Lone](https://forum.xojo.com/u/Greg_O_Lone)\
**Post date:** [November 28, 2015, 2:23pm UTC](https://forum.xojo.com/t/mysql-upgrade-and-weird-problems/28312/2 "2015-11-28T14:23:49Z")

</div>

Is there any info in the ErrorMessage property?

---

<div class="post-metadata">

**Author:** ![Jeff\_Tullin](https://forum.xojo.com/user_avatar/forum.xojo.com/jeff_tullin/32/693_2.png) [@Jeff\_Tullin](https://forum.xojo.com/u/Jeff_Tullin)\
**Post date:** [November 28, 2015, 7:11pm UTC](https://forum.xojo.com/t/mysql-upgrade-and-weird-problems/28312/3 "2015-11-28T19:11:07Z")

</div>

> [@](#):
>
> even “select table.\* from table” returns one row

How do you check that?  
Are you looping through until LastRecord after making sure you start at FirstRecord?  
Or are you asking for a RecordCount?

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [October 29, 2020, 6:04pm UTC](https://forum.xojo.com/t/mysql-upgrade-and-weird-problems/28312/4 "2020-10-29T18:04:38Z")

</div>