Converting Legacy Code Helpdesk Plugin Circa 2007 to work with Latest E107 and PHP 8.2 #5358
Replies: 19 comments 16 replies
-
|
Hi, Database issues are related to changes in e107 db functions, they are not compatible (regardless of what they say) I updated the gold system (not used anymore), if you go through the commits, you will see what to change. Do you mean this plugin? Or something else? If you want help from me, please create a new repo under your account and upload the original code there. I prefer to tell you what is wrong a show you how to fix it, not do your work. My time is limited. It is a pity that you haven't asked sooner when I updated those old plugins a lot. |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
Yes thats the one. I was using Chat GPT to fix deprecated files but it
still doesnt work ,
Might upload whole project and see if it can fix it because it seems to be
several files.
…On Thu, Dec 5, 2024 at 1:13 AM Jimako ***@***.***> wrote:
Hi,
not working for PHP 8 is mainly a constant issue. You need to fix all
warnings in PHP 7 first. (PHP 8 has a blank page, fatal errors)
Database issues are related to changes in e107 db functions, they are not
compatible (regardless of what they say)
I updated the gold system (not used anymore), if you go through the
commits, you will see what to change.
https://github.com/Jimako-e107-plugins/e107-Gold-System
Do you mean this plugin? Or something else?
https://github.com/Jimako-e107-plugins/e107-old-plugins/tree/master/helpdesk3_menu_V3.4/helpdesk3_menu
If you want help from me, please create a new repo under your account and
upload the original code there. I prefer to tell you what is wrong a show
you how to fix it, not do your work. My time is limited. It is a pity that
you haven't asked sooner when I updated those old plugins a lot.
—
Reply to this email directly, view it on GitHub
<#5358 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ANREX2AQJIXLT22FDWFRFOD2EADKRAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNBXGAYTCOI>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
--
*Paul Bulris *
*CompTIA (A+ Server + Network + Linux + Security +)*
*Microsoft (MCSE MCP ) *
*Cisco (CCNA CCNP) Certified *
*BaxterSpace Information Technology*
***@***.*** ***@***.***>229 444 2534*
|
Beta Was this translation helpful? Give feedback.
-
|
So i would appear as though if I could just solve this issue everything would work, With a few deprecated files fixes the helpdesk systems works itself out in PHP 8.2 but crashes because E107 does not run on 8.2 well. I have a another major problem , however , and maybe you can advise on how to fix this , but several fields in E107 cannot write to database on PHP 7.4 , even the welcome message will not take in effect changes, as first I thought it was a cache or sessions issue , but its not , it appears it is just unable to to acccess database. My server has multi-php so I can switch to php 8.2 and update the welcome message and a few other fields before it crashes and then switch back to 7.4 , but cannot make many if any changes in E107 running on PHP 7.4 , It wont even let me change the site logo, welcome message, tag line , basic things I should be able to change, and again can change running on 8.2 |
Beta Was this translation helpful? Give feedback.
-
|
Hi Baxter which e107 version do you use? Sorry my bad... :-) (edited) |
Beta Was this translation helpful? Give feedback.
-
|
2.3.3 trying to get it to run on PHP. 8.2.
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
…On Thu, Dec 5, 2024, 10:41 AM Alex ***@***.***> wrote:
Hi Baxter which e107 version do you use?
—
Reply to this email directly, view it on GitHub
<#5358 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ANREX2GZGRKXZ7RJ2HZNFTL2ECF6JAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNBXGYZDONY>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
2.3.3 is already outdated, with some bugs. With PHP 8.2 you need to use developer version from here. |
Beta Was this translation helpful? Give feedback.
-
|
Ok, thanks. I use the help desk code from here and that solved a few
things, but there's still a lot of bugs in the code and still a lot of
deprecated issues even with the version that's on here. So I've been
working with a couple different methods of using chat. GPT and Microsoft to
step through all the deprecations and fix the code up to date to 8.2. so my
ultimate goal is to get a107 and the help desk menu working on 8-2. The
outstanding issue I'm having now is that on PHP 74 it will not write to the
database for whatever reason . And like I said it works on 8 2 but then
there's all kinds of other errors. I'm really close to getting this
working! Super excited to see this working again as I really miss using
e107!
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
…On Sun, Dec 8, 2024, 2:46 AM Jimako ***@***.***> wrote:
2.3.3 is already outdated, with some bugs. With PHP 8.2 you need to use
developer version from here.
—
Reply to this email directly, view it on GitHub
<#5358 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ANREX2DQPI7ARWO5CHZHJML2EQIOXAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNBZHA2TGNI>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
I put the whole help desk version from get into Chat. GPT And it fixed a
ton of stuff. For instance, changing all the vars to public, but with that
it also caused other issues like some of the menus because of I guess the
language file instead of displaying what they are in the fields, it
displays the VAR name and not the name of what the field is. So there's
that issue I still haven't figured out yet.
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
…On Sun, Dec 8, 2024, 1:02 PM Paul E ***@***.***> wrote:
Ok, thanks. I use the help desk code from here and that solved a few
things, but there's still a lot of bugs in the code and still a lot of
deprecated issues even with the version that's on here. So I've been
working with a couple different methods of using chat. GPT and Microsoft to
step through all the deprecations and fix the code up to date to 8.2. so my
ultimate goal is to get a107 and the help desk menu working on 8-2. The
outstanding issue I'm having now is that on PHP 74 it will not write to the
database for whatever reason . And like I said it works on 8 2 but then
there's all kinds of other errors. I'm really close to getting this
working! Super excited to see this working again as I really miss using
e107!
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
On Sun, Dec 8, 2024, 2:46 AM Jimako ***@***.***> wrote:
> 2.3.3 is already outdated, with some bugs. With PHP 8.2 you need to use
> developer version from here.
>
> —
> Reply to this email directly, view it on GitHub
> <#5358 (reply in thread)>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/ANREX2DQPI7ARWO5CHZHJML2EQIOXAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNBZHA2TGNI>
> .
> You are receiving this because you authored the thread.Message ID:
> ***@***.***>
>
|
Beta Was this translation helpful? Give feedback.
-
|
Besides issues with undefined CONSTANTS causing errors, the count() and foreach() and other array() functions now throw errors if the $variable is not an array. It boggles my mind why PHP decided to throw an error instead of returning nothing. (thinking about this, I wonder if there are php.ini settings that could be changed to change this) |
Beta Was this translation helpful? Give feedback.
-
|
just mentioning, to be taken in consideration??. A difference also (unsure if its a 'bummer'; due to dbase problems) MyISAM vs InnoDb tables. Although it should work, but no idea iff relation to old coding methods. |
Beta Was this translation helpful? Give feedback.
-
|
Noticed this to . It works in PHP 8.2 with database so that doesn't seem to be an issue. It just crashes because code around it mainly admin_config.php and includes/helpdesk_class.php, I feel like if I could get these two files working at least I would be there I am so close. |
Beta Was this translation helpful? Give feedback.
-
|
@BaxterSpace you can't use GPT for this if you are not familiar with old and code, debugging their answers related to e107... But as soon as you help it a bit with correct way, it is big help. Ok, I will try to do it... I have some hours. My way with repo and issues, at first renaming and removing _menu from plugin folder. |
Beta Was this translation helpful? Give feedback.
-
|
The first is the fix for PHP 7.4. and latest e107 (2.4) Here is the repo Here is the result for me after installing
I need to know what wasn't working in PHP 7 |
Beta Was this translation helpful? Give feedback.
-
I still am unable to get ANY of the posted GIT versions to work on my server. Dont Know what I am doing wrong at this point. The closest I have come 80 hours later into this is the original version I started with kind of works but cannot make changes admin_config.php such as user class , who can post, title of helpdesk etc. I can get it to load just as you say in the screenshots yes , that is not the issue but I cannot make any changes to configuration or I keep getting 404 errors . |
Beta Was this translation helpful? Give feedback.
-
|
Have you ever checked your database with Tools/Database/Check tables or so? Without access to your site, admin, database, or FTP... nobody can tell—or at least an exported database. |
Beta Was this translation helpful? Give feedback.
-
|
Ok, I'll check it out. I really appreciate that thank you. What wasn't
working in 7-4 before? Was it wasn't able to write to the database. For
instance, when you would fill out or create a ticket it would not actually
be created
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
…On Mon, Dec 9, 2024, 6:27 AM Jimako ***@***.***> wrote:
The first is the fix for PHP 7.4. and latest e107 (2.4)
Here is the repo
https://github.com/Jimako-e107-plugins/helpdesk3
Here is the result for me after installing
image.png (view on web)
<https://github.com/user-attachments/assets/c911b753-f6b1-4a9d-8ce0-2419999ecf1e>
image.png (view on web)
<https://github.com/user-attachments/assets/10205df3-241d-4fe7-8304-16bb29c4153a>
I need to know what wasn't working in *PHP 7*
—
Reply to this email directly, view it on GitHub
<#5358 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ANREX2EO4SHFPWGY3SX62L32EWLDRAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNJQHAZTSMI>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Odd , it works with original Code in your repo that says .6 , but same issue, it can load then menu yes, but it cant actually do anything. |
Beta Was this translation helpful? Give feedback.
-
|
As you see in my screenshots, it works for me - tickets are saved. Editable. Preferences fixed. The Helpdesk3 plugin has now separated the repo. If you want to fix it, you need to create a normal issue there with screenshots or detailed descriptions. |
Beta Was this translation helpful? Give feedback.
-
|
Just to be clear which folder is the updated code for helpdesk3 ? I was assuming it was the newer one but that just seems to break the code. I copied the code from the Git master e107 to my directory but i still says version 2.3.3 So not sure how I can update it further? |
Beta Was this translation helpful? Give feedback.
-
|
Correction it now says I am on e107 |
Beta Was this translation helpful? Give feedback.
-
|
only folder helpdesk3, older version is just backup. I let you there issues with marking source of problem - that plugin has some bugs without e107 changes and PHP changes. I will close them soon.
|
Beta Was this translation helpful? Give feedback.
-
|
Fresh install 2.4.0, core bootstrap5 theme, installed helpdesk3 , saving prefs (no change), added category, added ticket on frontend for this category. Result: |
Beta Was this translation helpful? Give feedback.
-
|
Okay I will try that. On a side note, it appears the only part that it's
not able to write to is the first tab main configuration. I can actually
create a ticket categories help desks all of that, but I can't change the
main configuration tab such as the name of the helpdesk. Welcome message
things like that. But this does not appear to be an issue with just help
desk. It appears to be site wide with entire e107 site. Where there are
just certain areas I'm unable to write
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
…On Tue, Dec 10, 2024, 12:41 AM Jimako ***@***.***> wrote:
Fresh install 2.4.0, core bootstrap5 theme, installed helpdesk3 , saving
prefs (no change), added category, added ticket on frontend for this
category. Result:
image.png (view on web)
<https://github.com/user-attachments/assets/d0299bfa-28e2-4c97-95cf-b19dc6809943>
—
Reply to this email directly, view it on GitHub
<#5358 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ANREX2B43SXTOXEDKNJQ46T2E2LK5AVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNJRG4YDCNA>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
Are you aware that I am not a user of that plugin? That I don't know what you have on mind? This? It works.
|
Beta Was this translation helpful? Give feedback.
-
|
Also, e107 does have a debug thing. Just have to add something to the end
of your url to show warnings/errors. That should help you debug your code.
…On Tue, Dec 10, 2024, 1:41 AM Jimako ***@***.***> wrote:
Fresh install 2.4.0, core bootstrap5 theme, installed helpdesk3 , saving
prefs (no change), added category, added ticket on frontend for this
category. Result:
image.png (view on web)
<https://github.com/user-attachments/assets/d0299bfa-28e2-4c97-95cf-b19dc6809943>
—
Reply to this email directly, view it on GitHub
<#5358 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABMMNJWLPCOHHFAPV56EQIL2E2LLDAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNJRG4YDCNA>
.
You are receiving this because you are subscribed to this thread.Message
ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
I did this. So any visible error is fixed now. |
Beta Was this translation helpful? Give feedback.
-
|
Yeah I have the debugger on but it doesn't help when it just shows a blank
page because it still does not show the errors.. I only see Errors if at
least loads the e107 part , I've even tried forcing it and php ini and I
and httpd.conf , And when I have a php fatal error I get nothing but a
blank page with not errors . This only happens when I try to use it on PHP
8.2.
And like I mentioned earlier There are several Fields I'm only able to
write in when running on 7.4 .
The main configuration file on the help desk menu the very first option
where you set your first main options.. but also have noticed that a lot of
other things and the regular e107 environment do not work either and I
think it might be a database issue because this only happens in e107
running on 7-4. If I use multi-php manager and switched to 8.2 I can make
updates on e107 and help desk but eventually it crashes and I get white
blank page again.
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
…On Tue, Dec 10, 2024, 1:07 AM Jimako ***@***.***> wrote:
I did this. So any visible error is fixed now.
—
Reply to this email directly, view it on GitHub
<#5358 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ANREX2GAW2OWRYOZJZKNKL32E2OKNAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNJRG4ZDKOA>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
I think one viable solution I can try is to try to install from scratch.
E107 new database, using the git version , using Jankos repo for updated
files , and run E107 on php 8.2 with helpdesk running on 7.4.. but that may
still not work. If if what another person suggested is that it may be issue
with the Myisam tables or something in the database, which again isnt an
issue on 8.2 but is only on 7.4 so I would be round about to the same
place I am place. And this would also explain why it works on your server
but not mine. My server just has a funky way of using Multi PHP Manager ,
because I'm also thinking I didn't have these particular issues on my other
server either but I had a plethora of other ones.
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
…On Tue, Dec 10, 2024, 1:12 AM Paul E ***@***.***> wrote:
Yeah I have the debugger on but it doesn't help when it just shows a blank
page because it still does not show the errors.. I only see Errors if at
least loads the e107 part , I've even tried forcing it and php ini and I
and httpd.conf , And when I have a php fatal error I get nothing but a
blank page with not errors . This only happens when I try to use it on PHP
8.2.
And like I mentioned earlier There are several Fields I'm only able to
write in when running on 7.4 .
The main configuration file on the help desk menu the very first option
where you set your first main options.. but also have noticed that a lot of
other things and the regular e107 environment do not work either and I
think it might be a database issue because this only happens in e107
running on 7-4. If I use multi-php manager and switched to 8.2 I can make
updates on e107 and help desk but eventually it crashes and I get white
blank page again.
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
On Tue, Dec 10, 2024, 1:07 AM Jimako ***@***.***> wrote:
> I did this. So any visible error is fixed now.
>
> —
> Reply to this email directly, view it on GitHub
> <#5358 (reply in thread)>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/ANREX2GAW2OWRYOZJZKNKL32E2OKNAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNJRG4ZDKOA>
> .
> You are receiving this because you were mentioned.Message ID:
> ***@***.***>
>
|
Beta Was this translation helpful? Give feedback.
-
|
hmm just tried local with latest files from @Jimmi08 's repo Method used : uploaded into plugins, installed, configure : (what to do and just tried) >no cat etc.. so created that and thats all As you can see my dbase server uses MySQL (installed in it) and both InnoDB and MyISAM work together in dbase..
|
Beta Was this translation helpful? Give feedback.
-
|
@tgtje THANKS! Engine - I just forgot to change it but e107 is doing it yourself if I am not mistaken. With some settings or only for core plugins... |
Beta Was this translation helpful? Give feedback.
-
|
@Jimmi08 Your welcome, but anything you do to it, is your decision. |
Beta Was this translation helpful? Give feedback.
-
|
@leo It would be great , to see it working and fully functioning, I had it
working at one time believe it or not in 2009-2012 And even had added a
lot of custom stuff to it as well ,but have not been able to get it back
working since for one reason or the other. My main constraint is time too
because I've already spent like 60 something hours trying to get this
working and I'm back to square one still. So if I could get this latest
repo working at least in 7.4, I would just be happy with that at this
point. Also, I am on Alma Linux so wondering if I might just be in some
quirky situation with that too.
Paul Bulris
CompTIA (A+ Server + Network + Linux + Security +)
Microsoft (MCSE MCP )
Cisco (CCNA CCNP) Certified
BaxterSpace Information Technology
***@***.***
229 444 2534
…On Tue, Dec 10, 2024, 6:50 AM leo ***@***.***> wrote:
Your welcome, but anything you do to it, is your decision.
I think it would be nonetheless a good plugin for sites that relate to
people having issues.
It's a pity that Father Barry (Keal) (yep a real priest) aka G4HDU stopped
years ago. Health gets us all.
He had a lot of usefull things. On Github some still exists (history
<https://github.com/search?q=G4HDU&type=users>). end 2019.
As for the left menu issue (unsure your idea) take a look at these
<https://github.com/e107inc/e107/tree/master/e107_languages/English/admin/help>,
they still work (method) , but i started with translation, but everything
is all over the core..so put a hold on that.
—
Reply to this email directly, view it on GitHub
<#5358 (reply in thread)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ANREX2AVMJ3XXS352OYJ5ML2E3WUBAVCNFSM6AAAAABTBRUSVGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNJSGEZTCNA>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
@BaxterSpace Well reading in on AlmaLinux, going through forum there..alma 8 or 9? 9 should support 7.4 But being 7.4 to be seen as depricated, and Alma (afaic see) uses SQL version max 8.. >>> hard to say if that is a culprit ( from a external post: The issues with authentication methods were fixed in PHP 7.4 (since 7.4.4 should be working perfectly fine) From 7.4 to 8.3 all running, however there is influence of MySQL version (using 8.2!!!) if it gets too low (i presume)(; only a version 5 running for old v1 installs + same by phpadmin versions). might cause conflict or misbehaviour. |
Beta Was this translation helpful? Give feedback.
-
|
Hi, About 'Father Barry'. He is still alive and he is in my Friends List of Facebook. He is a Hamradio Operator like me, but I do not think he is a Father anymore. He give up on E107, but I can't remember what his reasons were. I know he is/was disappointed in E107 about the road they went with E107. I will give him a shout about this plugin. What do you want to know about the plugin? Kind regards and a Happy New Year, |
Beta Was this translation helpful? Give feedback.
-
Greetings All,
I know this is a long shot with here , but this is what I am up against.
Basically I found a helpdesk plugin for E107 that worked perfect for my business called helpdesk V3 written by a guy named Father Barry in 2007 . The website is defuct and theres not information anywhere about where this guy went or what happened .
It was working perfectly back then probably on PHP 4.0 or whatever I was running back then I dont even know anymore, since then in 2012 I was able to run it throught a processor script and get it working with newer versions of PHP and E107 and shelved it again because it still was really buggy. By some miracle it is working in PHP 7.4 on the latest version of E107 2.33 .
IT INTSALLS AND WORKS !
But one little problem. It won't write to the database in some fields and little things do not work here and there.
Have the same issue with other things as well with E107 running on 7.4 , just a lot of things DO NOT WORK, and just get black pages with no errors with 8.2 , even with error reporting on all it gives is a 500 error so that is super not helpful.... Have been fighting this for 100s of hours and at a loss flipping back between 8.2 and 7.4. It looks like at the end of the day there is just no real way to get it work at all with 8.2 and on 7.4 it can't write to the database in several tables so not doing me much good here.
My options are find a way to make it work on 7.4 which involves trying to figure out why E107 and 7.4 are having issues or running all the code through another processor script that converts all the code to 8.2 which I have already tried and not having success with either.
Any Ideas anyone?
Beta Was this translation helpful? Give feedback.
All reactions