SQL problem

plopje_kabouter · **Posted:** Sat Nov 07, 2009 4:10 pm

I have changed the names of the SQL tables for 'jos_' to 'jip_' for security reasons. This always works well with the extensions and modules and If not I know who to fix it till now

I have a scroller module that want to connect to the SQL tables:

Code:

#__sobi2_item
#__sobi2_cat_items_relations

The module does not give an error on the website it but leaves the pages blank. Can anyone give me a hint how I can change the code in the .php file of the module so it connects to the right tables.

I don't have much knowledge of SQL databases so maybe stupid question but does the "#_" in #__sobi2_item

Thank you for you help

Bjorg · **Joined:** Tue Jul 07, 2009 4:45 am **Posts:** 614

Try:

http://docs.joomla.org/How_to_use_the_d ... our_script

Hope this helps!

plopje_kabouter · **Posted:** Mon Nov 09, 2009 8:29 pm

Thanks man, interesting article! Checked everything in the module file but couldn't find any bug

anyway thank you for the help

Bjorg · **Joined:** Tue Jul 07, 2009 4:45 am **Posts:** 614

NP:)
Interesting enough, do the tables have data?

jdavis74 · **Joined:** Fri Jul 03, 2009 5:38 pm **Posts:** 355

If you're getting an entirely blank white screen, you probably have a problem with some php settings. Check the apache error logs to see the issue.

Bjorg · **Joined:** Tue Jul 07, 2009 4:45 am **Posts:** 614

This thread seems similar:
viewtopic.php?f=430&t=291029

Hope this helps!

plopje_kabouter · **Posted:** Wed Nov 18, 2009 3:46 pm

The apache error logs are kept by the provider so don't really know how to access them.

I also check the other post and my config file and path are correct. Next to that I checked the sobi2 forum where the module came from, also there no solution or response

Strange, but maybe it will solve by itself when a new update come out of php or the SQL server.

Thanks guys for the help.

Bjorg · **Joined:** Tue Jul 07, 2009 4:45 am **Posts:** 614

To change the table names, the cooresponding php file(s) need changed as well depending on how they call and write to teh sql.

Try to change them back to the original names, also make sure the tables are UTF-8.

Just a thought...

Joomla! Discussion Forums

Forum rules

SQL problem

Quick reply

Who is online