Announcement

#1 2017-08-30 20:57:38

Marshal
Member
2017-08-30
2

DataTables warning (table id = 'userList') when PayPal is enabled

Greetings smart young programmers,

I can't see any users under MANAGE - USER LIST despite changing the date_default_timezone_set using LocalFiles Editor and hard coding it to
date_default_timezone_set('America/Indiana/Indianapolis');  in all functions.inc.php files as well as the admin.php file in the PayPal Plugin directory.

If I DEACTIVATE the Plugin...User List works...ACTIVATEd Plugin....No Users and an error box.

I get the feeling from other posts that this is a JSON parse error but I can't figure out why the cart plugin would cause it or how to fix it. I'm not a
webdesigner...just a amature hacker who's gotten good at "changing just this one thing"...thus my very customized version of Piwigo 2.8.6 where I've "hidden"
everything my Business Owner shouldn't touch.

But this problem has occured since my original "clean" Piwigo install and "clean" PayPal Cart Plugin install. Please help an old "356 techy" gal out!

These are my details as I could figure out.

I'm using CPANEL through GreenGeeks and don't have access to php.ini

My enviorment is :
        Operating system: Linux
        PHP: 5.5.38 (Show info) [2017-08-30 13:27:51]
        MySQL: 10.0.32-MariaDB [2017-08-30 12:27:51]
        Graphics Library: ImageMagick 6.9.4-10

web browser console request on admin/user_list_backend.php results are:

    under PREVIEW
    {"sEcho":1,"iTotalRecords":"3","iTotalDisplayRecords":"3","aaData":[["1","Marshal","Webmaster","[email protected]","","Admins","2016-09-12 15:27:18"],["2","guest","Guest",null,"","","2016-09-12 15:27:18"],["3","Patrick","Webmaster","[email protected]","","Admins","2017-03-16 09:42:57"]]}
........................................................................
    status code is {green} 200
........................................................................   
    when EDIT AND RESEND is activated this is the response
    Host: www.gbphotoplus.com
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0
Accept: application/json, text/javascript, */*; q=0.01
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate, br
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
X-Requested-With: XMLHttpRequest
Referer: https://www.gbphotoplus.com/Piwigo/admi … =user_list
Content-Length: 677
Cookie: pwg_id=g1lbfhplof04cuh744896pph97; __cfduid=d5701e770b5d31a8f8dff578b262e75b41499264728; PHPSESSID=f3156jt41smqurb1qk78rrgb86
Connection: keep-alive
Cache-Control: max-age=0

    PARMS displays
    sEcho    "1"
iColumns    "7"
sColumns    ",,,,,,"
iDisplayStart    "0"
iDisplayLength    "10"
mDataProp_0    "0"
sSearch_0    ""
bRegex_0    "false"
bSearchable_0    "true"
bSortable_0    "true"
mDataProp_1    "1"
sSearch_1    ""
bRegex_1    "false"
bSearchable_1    "true"
bSortable_1    "true"
mDataProp_2    "2"
sSearch_2    ""
bRegex_2    "false"
bSearchable_2    "true"
bSortable_2    "true"
mDataProp_3    "3"
sSearch_3    ""
bRegex_3    "false"
bSearchable_3    "true"
bSortable_3    "true"
mDataProp_4    "4"
sSearch_4    ""
bRegex_4    "false"
bSearchable_4    "true"
bSortable_4    "true"
mDataProp_5    "5"
sSearch_5    ""
bRegex_5    "false"
bSearchable_5    "true"
bSortable_5    "true"
mDataProp_6    "6"
sSearch_6    ""
bRegex_6    "false"
bSearchable_6    "true"
bSortable_6    "true"
sSearch    ""
bRegex    "false"
iSortCol_0    "0"
sSortDir_0    "asc"
iSortingCols    "1"

Offline

 

#2 2017-08-31 12:54:24

flop25
Piwigo Team
2006-07-06
7037

Re: DataTables warning (table id = 'userList') when PayPal is enabled

Hello
Okay sounds a tricky one ; try first to repair mysql tables and Restore the plugin (after a screenshot/copy-past ... of the config if it has one)


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2017-10-04 16:44:12

Marshal
Member
2017-08-30
2

Re: DataTables warning (table id = 'userList') when PayPal is enabled

Thank you, yes I specialize in "tricky"...usually because I create the situation myself!
[Sorry for such a long delay in response, I've been quite ill]

I can't restore the plugin because it has been highly customized to support individual pricing of albums, both the linklok and vibracart systems,  free downloads, and special packages.

I'm not aware of anything wrong in the data table that would need repairing especially as I don't get this error when the plugin is deactivated???

But, more importantly, I'm new to data bases so if you wish me to "repair" it ... could you point me to a how-to to do so? As I don't see any menu selections under [phpMyAdmin] to do so.

BTW Which [config] file? There's an awful lot of them running around in here.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact