1
Bluenoser
XoopsFormSelect formatting data
  • 2013/4/27 3:20

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


I am trying to add additional information to the XoopsFormSelect. I am trying to add information to the value to colour each drop down element. Here is my code.

class GAFormSelecttee_names extends XoopsFormSelect {
      function 
GAFormSelecttee_names($caption$name$value=nullsize=1$nullopt=false$otheropt=false) {
         
$db =& Database::getInstance();
         
$this->XoopsFormSelect($caption$name$value$size);
         if (
$nullopt)
             
$this->addOption('','-');
         
$sql "SELECT tee_name_id, name, fgcolour, bgcolour FROM ".$db->prefix("ga_tee_names")." ORDER BY name";
         
$result $db->query($sql);
         while (
$myrow $db->fetchArray($result)) {
           
$this->addOption($myrow['tee_name_id'].'" style="background-color:'.$myrow['bgcolour'].';color:'.$myrow['fgcolour'].';',$myrow['name']);
         }
      }
 }


The problem is that my " get converted to the HTML equiv of "

Anyway I can prevent this?



2
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/24 0:49

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


So I updated the version of PHP from 5.3.8 to 5.3.21 and still have the exact same problems. Only going back to 5.2.14 will it work correctly.

Is there any special additional configuration that needs to be done when moving from 5.2 to 5.3?



3
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/23 13:31

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


Finally figured it out. SUSE Linux Enterprise Server comes with PHP 5.2.14 and 5.3.8. When I install the 5.2.14 and install XOOPS, everything works great. When I install 5.3.8. I get all the problems that I have described.

So there is something in the new 5.3.8 which prevents full functionality. Does anyone know what in PHP would make this work in 5.2 and not in 5.3?



4
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/21 3:26

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


I did some more testing. Installed 2.6 alpha 2 and still have the same problems. Installed phpMyAdmin and was able to create/edit and delete the xoops databases with no problems.



5
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/20 23:07

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


One other thing. When looking at the Users Management, it tells me I have 2 user(s) found, yet the table only shows one.



6
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/20 23:00

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


Hi,

I was on vacation, so I haven't had time to do anymore testing.

Today I:

Deleted everything and started again. I installed a clean version of 2.5.5. I still have the problem where the admin account cannot change anything. A couple of observations.

If I try to login and don't have the Remember me checked I cannot login from the "Login" block. If it is checked, I login no problem.

It looks like xoops doesn't see me (admin) as someone who can change settings. For example, if I try and delete a banner, it goes through all the steps and I can see all the queries in the debug. There is no delete. If I login to mysql as the user that is in the secure.php file, I can delete the record with no problems. So there isn't a permission problem with mySQL. Since I never see a DELETE query failure or even a DELETE, it is like it never happens. And I see INSERTS and UPDATES to protector and banner tables.

I have tried this on three computers with different browsers and everything works the same way.

I want to use XOOPS as I have been using it for years, but I am getting frustrated that I can't install this version. This isn't the first time I have installed XOOPS. And the install says that I have all the requirements and passed all the tests.

I am using SUSE 11 SP2 with mySQL 5.0.98 and PHP 5.3.8



7
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/6 23:44

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


Quote:

Mamba wrote:
Just for test purposes, can you try to install the beta version of XOOPS 2.5.6, and see if there is any difference?

You'll need 7zip to uncompress the file


I hope you don't mind that I would like to try and get a non-beta version working.



8
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/6 23:43

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


Quote:

xoobaru wrote:
Without php or Apache error logs generated during installation, there is no way to rule out a PHP or server related problem which it sounds like you are having. Are you hosting this on your own machine or with a hosting service?

Do you have another script of some sort you can install using the same DB to test if it too has similar problem writing to your database? Go to hotscipts.com and try a free one.

Lastly, any runonce php script lines in a php file or the template you are using that is configured for script (stats etc.) that no longer exists?


There is nothing in the apache error log. There is no errors reported by the debug in xoops. The installation program wrote to the database and every time I try to login, it writes a new session record. Also the installation program write all the configuration records.

The only thing that I could find odd is a record in the access_log of Apache 2.

::1 - - [06/Feb/2013:16:29:59 -0400] "OPTIONS * HTTP/1.0" 200 - "-" "Apache/2.2.12 (Linux/SUSE) (internal dummy connection)"
::1 - - [06/Feb/2013:16:30:00 -0400] "OPTIONS * HTTP/1.0" 200 - "-" "Apache/2.2.12 (Linux/SUSE) (internal dummy connection)"

This installation is a new one with nothing added.




9
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/6 22:20

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


Quote:

xoobaru wrote:
What happens when you try to register as new user?


No user is added.



10
Bluenoser
Re: Initial 2.5.5 Usage Problems
  • 2013/2/6 22:18

  • Bluenoser

  • Just popping in

  • Posts: 24

  • Since: 2007/6/5 1


I also manually edited the config table so I could enable debugging. There are no errors reported, but also there are no SQL UPDATES when things are changed.




TopTop
(1) 2 »



Login

Who's Online

215 user(s) are online (141 user(s) are browsing Support Forums)


Members: 0


Guests: 215


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits