1
jlm69
2.6.0 search module errors
  • 2015/7/26 11:45

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


In the search, on my modules search pages, everything works perfectly. If I use Xoops search I get errors caused by using 'IN' in mysql. Xoops seems to not know what to do with 'IN'. It does not matter how I do it like this:

$criteria->add(new Criteria('cid', '('.$all_ids.')', 'IN'));

or like this

->andWhere($eb->in('cid', $jobs_ids))

like I said they work perfectly in the search within my modules, but if I try the search module it does not treat 'IN' properly.
In the first example it treats 'in' like '<>' which produces no results when there are results.

0.000310 - SELECT * FROM alumni_listing WHERE (valid = :dcValue1 AND cid <> cid AND name LIKE :dcValue2 OR mname LIKE :dcValue3
OR lname LIKE :dcValue4 OR year LIKE :dcValue5) ORDER BY date DESC LIMIT 5 OFFSET 0


In the second example it throughs an exeption.


You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
near ')) AND ((title LIKE '%test%') OR (type LIKE '%test%') OR (company LIKE '%test%')' at line 1' in
LIB/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91

If I remove the lines it works, except it shows all results even if you don't have permission to see them.

PHP - 5.6.10
MYSQL - 5.5.5-10.0.19-MariaDB

Thanks,
John



2
jlm69
2.6.0 showing username and password in error message
  • 2015/7/26 11:41

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


if the database goes down, even if logger is turned off in preferences, your username and password for mysql SHOWS
in the error message.

Just turn off mysql and try to use your site.

PHP - 5.6.10)
MYSQL - 5.5.5-10.0.19-MariaDB

Thanks,
John



3
jlm69
Re: Installing 2.6.0 get fatal error
  • 2015/7/16 19:04

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


Dante,
Thanks, this is what I had in .htaccess

# Custom Legacy PHP 5.3 handler placed by host
AddType application/x-httpd-php53 .php5 .php4 .php .php3 .php2 .phtml
suPHP_ConfigPath /usr/local/lib/php53.ini
# End Custom Legacy PHP 5.3 handler placed by host


I just needed to delete those lines.

But then I got this error on the module install page

Parse error: syntax error, unexpected 'return' (T_RETURN) in /home/xxxx/public_html/xxx/class/xoopseditor/tinymce4/editor_registry.php on line 1

I just deleted tinymce4 and everything worked great.

Thanks for showing me where to look.

John




4
jlm69
Installing 2.6.0 get fatal error
  • 2015/7/16 11:09

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


first problem is weird,

My cpanel shows I have php - 5.4.41 but all my Xoops running on this server say
php 5.3.26, which shows a red X for php in my installation of 2.6.0. If I just continue, when I get to

mysite/install/page_configsite.php

I get this error

Fatal error: Interface 'SessionHandlerInterface' not found in /home/jlmzone/260/xoops_lib/Xoops/Core/Session/Handler.php on line 27

What is the min php for 2.6.0?

In all the modules in 2.6.0 it says

$modversion['min_php'] = '5.3.7';

but I get a red X for min php when installing saying I have 5.3.26
which is higher than 5.3.7 and again my cpanel says php - 5.4.41

Anyone have any ideas?

Thanks,

John






5
jlm69
Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub
  • 2015/6/4 15:45

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


I will keep my modules on my server, I did not want to have to open a github account, but it seems You have to, to install Xoops Now. Which I think is very wrong.

But anyway i will keep it on my site, if anyone wants they can send me changes they want to make and I will maybe add them if I like it.

Since when did the meaning of the word fork change? To me fork will ALWAYS mean taking the software and creating your own thing out of it. Like ICMS is a fork of Xoops. Who ever changed the meaning of that word was wrong to do so.

Anyway I have updated my Alumni module today because there was no link to add categories in the admin section. I will upload the changes as soon as I post this.

@ Mamba
I will pm you in a little while I have a question for you.

Thanks,
John



6
jlm69
Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub
  • 2015/6/1 22:09

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


I have just released the second version of Alumni 3.1 ALPHA.

You can get Alumni 3.1 ALPHA 2 HERE

This works for me with Xoops 2.6.0 ALPHA on Github as of today.

Thanks,
John



7
jlm69
Re: Jobs Listings 4.4 Beta 2
  • 2014/7/28 20:08

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


Are you sure you gave the right permissions AFTER you added any new categories?
What version of Xoops are you using?

John



8
jlm69
Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub
  • 2014/5/31 16:33

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


O.K. I fixed it. It should work now.

Thanks,
John



9
jlm69
Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub
  • 2014/5/31 12:00

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


You must have an even newer version of Xoops than me. I will see about updating mine.
I don't plan on opening an account on GitHub.
Thanks for the input.
If those caused errors then there would probably be alot of others, right?

Thanks,

John



10
jlm69
Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub - Released
  • 2014/5/27 21:45

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub

I HAVE RELEASED THIS FOR TESTING AND INFORMATIONAL USE ONLY.
It is for Xoops 2.6.0 ALPHA from GitHub

When I started my goal was to allow my module to work with Xoops 2.6.0 ALPHA and make every page work with no errors, warnings or depreciated functions.
I think I have done that. Except for 1 notice in the search pages, will fix that eventually.

Any database calls that use fetchRow or getRowsNum needed to be replaced.
even others when you change $xoppsDB to $xoops->db() would blowup the page.
Basically I had to remove all database calls and do it through classes.
Had to totally redo the search pages.

I used a few modules for examples of what I needed to do, they are
mylinks, page, publisher, profile and new and old versions of wfdownloads

Because I am using tablesorter I have moved the use banner code or index code to the top of the listings instead of somewhere in between listings.(just in category pages)
on the alumni home page the use banner code or index code still works the same.


TO DO:

* Have not updated the waiting plugin
* Notifications don't work because a regular user can not access that area, so I can't test it.
* Will only work with the 'use_categories' config option set to yes, I haven't gone through it and added that, wondering if I need that.
* Rewrite the sendfriend page.
* Rewrite the print page.
* Add IP log to contact page.


And everything works for me. Knock on wood.

You can get it HERE!

If you have any issues with this module please report it on Xoops.


Thanks,

John




TopTop
(1) 2 3 4 ... 53 »



Login

Username:
Password:

Lost Password? Register now!

Who's Online

55 user(s) are online (42 user(s) are browsing Support Forums)


Members: 0


Guests: 55


more...

Donat-O-Meter

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

Latest GitHub Commits