xoops forums

Forum Index


Board index » All Posts (jlm69)




jlm69

Module Developer
Posted on: 2015/7/26 11:45
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#1

2.6.0 search module errors

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


jlm69

Module Developer
Posted on: 2015/7/26 11:41
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#2

2.6.0 showing username and password in error message

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


jlm69

Module Developer
Posted on: 2015/7/16 19:04
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#3

Re: Installing 2.6.0 get fatal error

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



jlm69

Module Developer
Posted on: 2015/7/16 11:09
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#4

Installing 2.6.0 get fatal error

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





jlm69

Module Developer
Posted on: 2015/6/4 15:45
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#5

Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub

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


jlm69

Module Developer
Posted on: 2015/6/1 22:09
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#6

Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub

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


jlm69

Module Developer
Posted on: 2014/7/28 20:08
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#7

Re: Jobs Listings 4.4 Beta 2

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

John


jlm69

Module Developer
Posted on: 2014/5/31 16:33
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#8

Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub

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

Thanks,
John


jlm69

Module Developer
Posted on: 2014/5/31 12:00
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#9

Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub

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


jlm69

Module Developer
Posted on: 2014/5/27 21:45
jlm69
jlm69 (Show more)
Module Developer
Posts: 719
Since: 2002/7/19
#10

Re: Alumni version 3.1 ALPHA for Xoops 2.6.0 ALPHA from GitHub - Released

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 »