search

69GIAP / 69GIAPBosWar

1 stars 1 forks source link

MYSQLI UPDATE not working #116

Closed 69giapstenka closed 10 years ago

69giapstenka commented 10 years ago

I'm working on the exchange from a mission file to BOSWAR and this uses the database update call widely. For example I will read the Z X position of an object in a mission file then UPDATE table set xpos = new xpos, zpos = new zpos where objectname = objectname.

I test the syntax in MYSQL it works perfectly but when I do a mysqli call from within a BOSWAR php script it doesnt work and doesn't give an error message.

I looked at the database user rights grant and that looks OK.

I can't understand what is going wrong and development is at a complete standstill for several days now.

Maby php/mysql is corrupted in some way and I need a complete re-install?

69giapmyata commented 10 years ago

That sounds quite strange to me. I am in NY right now so I am not able to help troubleshooting at the moment, sorry.

69giapstenka commented 10 years ago

This is bizare update refused to work until I started using the full databasename.table syntax in the SQL call. With that in place it is running.

Inbetween times I discovered that static is a reserved word under php but not under sql. I subsequently renamed the static table to statics. It didn't fix the problem but was a good idea anyway.

Now I have hacked my way through the menus and am working on mission generation. Some of it is untidy and will need cleaning up but it seems to be working.