Getting Error 503 And Unable To Install

[vaidyamanishjoshi]

I am using wamp server on windows 11 with php 8.2
Trying to install LiveHelperChat
But Installation is very tough and clueless.

First I got Internal Server Error. I fixed it by renaming .htaccess file to xx.htaccess

Then I am getting errors at step 3 with many db tables creation... with error "Integrity constraint violation: 1062 Duplicate entry '1' for key" on tables lh_speech_language.PRIMARY, lh_abstract_email_template.PRIMARY

I am struggling to install it since last 3 hours with various editing tries... Till Not able to Install.

Current error show as follow -

Make sure that "cache/*" is writable and then try again
PDOException Object
(
[message:protected] => SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'lh_abstract_email_template.PRIMARY'
[string:Exception:private] =>
[code:protected] => 23000
[file:protected] => E:\wamp64\www\mywebsite.com\online-cme\chat\modules\lhinstall\install.php
[line:protected] => 1114
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => E:\wamp64\www\mywebsite.com\online-cme\chat\modules\lhinstall\install.php
[line] => 1114
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => INSERT INTO lh_abstract_email_template (id, translations, name, from_name, from_name_ac, from_email, from_email_ac, content, subject, subject_ac, reply_to, reply_to_ac, recipient, bcc_recipients, user_mail_as_sender) VALUES
(1,'', 'Send mail to user', 'Live Helper Chat', 0, '', 0, 'Dear {user_chat_nick},

{additional_message}

Live Support response:
{messages_content}

Sincerely,
Live Support Team
', '{name_surname} has responded to your request', 1, '', 1, '', '', 0),
(2,'', 'Support request from user', '', 0, '', 0, 'Hello,

User request data:
Name: {name}
Email: {email}
Phone: {phone}
Department: {department}
Country: {country}
City: {city}
IP: {ip}

Message:
{message}

Additional data, if any:
{additional_data}

URL of page from which user has send request:
{url_request}

Link to chat if any:
{prefillchat}

Sincerely,
Live Support Team', '{name}, {country}, {department}, Support request from user', 0, '', 0, '[email protected]', '', 0),
(3,'', 'User mail for himself', 'Live Helper Chat', 0, '', 0, 'Dear {user_chat_nick},

Transcript:
{messages_content}
Chat ID: {chat_id}

Sincerely,
Live Support Team
', 'Chat transcript', 0, '', 0, '', '', 0),
(4,'', 'New chat request', 'Live Helper Chat', 0, '', 0, 'Hello,

User request data:
Name: {name}
Email: {email}
Phone: {phone}
Department: {department}
Country: {country}
City: {city}
IP: {ip}
Created: {created}
User left: {user_left}
Waited: {waited}
Chat duration: {chat_duration}

Message:
{message}

URL of page from which user has send request:
{url_request}

Click to accept chat automatically
{url_accept}

Survey
{survey}

Sincerely,
Live Support Team', 'New chat request', 0, '', 0, '[email protected]', '', 0),
(5,'', 'Chat was closed', 'Live Helper Chat', 0, '', 0, 'Hello,

{operator} has closed a chat
Name: {name}
Email: {email}
Phone: {phone}
Department: {department}
Country: {country}
City: {city}
IP: {ip}
Created: {created}
User left: {user_left}
Waited: {waited}
Chat duration: {chat_duration}

Message:
{message}

Additional data, if any:
{additional_data}

URL of page from which user has send request:
{url_request}

Survey:
{survey}

Sincerely,
Live Support Team', 'Chat was closed', 0, '', 0, '[email protected]', '', 0),
(6,'', 'New FAQ question', 'Live Helper Chat', 0, '', 0, 'Hello,

New FAQ question
Email: {email}

Question:
{question}

Question URL:
{url_question}

URL to answer a question:
{url_request}

Sincerely,
Live Support Team', 'New FAQ question', 0, '', 0, '[email protected]', '', 0),
(7,'', 'New unread message', 'Live Helper Chat', 0, '', 0, 'Hello,

User request data:
Name: {name}
Email: {email}
Phone: {phone}
Department: {department}
Country: {country}
City: {city}
IP: {ip}
Created: {created}
User left: {user_left}
Waited: {waited}
Chat duration: {chat_duration}

Message:
{message}

URL of page from which user has send request:
{url_request}

Click to accept chat automatically
{url_accept}

Survey:
{survey}

Sincerely,
Live Support Team', 'New unread message', 0, '', 0, '[email protected]', '', 0),
(8,'', 'Filled form', 'MCFC', 0, '', 0, 'Hello,

User has filled a form
Form name - {form_name}
User IP - {ip}
Download filled data - {url_download}
View filled data - {url_view}

{content}

Sincerely,
Live Support Team', 'Filled form - {form_name}', 0, '', 0, '[email protected]', '', 0),
(9,'', 'Chat was accepted', 'Live Helper Chat', 0, '', 0, 'Hello,

Operator {user_name} has accepted a chat [{chat_id}]

User request data:
Name: {name}
Email: {email}
Phone: {phone}
Department: {department}
Country: {country}
City: {city}
IP: {ip}
Created: {created}
User left: {user_left}
Waited: {waited}
Chat duration: {chat_duration}

Message:
{message}

URL of page from which user has send request:
{url_request}

Click to accept chat automatically
{url_accept}

Survey:
{survey}

Sincerely,
Live Support Team', 'Chat was accepted [{chat_id}]', 0, '', 0, '[email protected]', '', 0),
(10,'', 'Permission request', 'Live Helper Chat', 0, '', 0, 'Hello,

Operator {user} has requested these permissions

{permissions}

Sincerely,
Live Support Team', 'Permission request from {user}', 0, '', 0, '', '', 0),
(11,'', 'You have unread messages', 'Live Helper Chat', 0, '', 0, 'Hello,

Operator {operator} has answered to you

{messages}

Sincerely,
Live Support Team', 'Operator has answered to your request', 0, '', 0, '', '', 0),
(12,'', 'Visitor returned', 'Live Helper Chat', 0, '', 0, 'Hello,

Visitor information
Name: {name}
Email: {email}
Phone: {phone}
Department: {department}
Country: {country}
City: {city}
IP: {ip}
Created: {created}
User left: {user_left}
Waited: {waited}
Chat duration: {chat_duration}

See more information at
{url_accept}

Last chat:
{message}

Additional data, if any:
{additional_data}

Sincerely,
Live Support Team', 'Visitor returned - {username}', 0, '', 0, '', '', 0),
(13,'','Report prepared', 'Live Helper Chat', 0, '', 0, 'Hello,

Report prepared - {report_name}, {date_range}

{report_description}

View report at:
{url_report}
View directly: {url_report_direct}', 'Report prepared - {report_name}', 0, '', 0, '', '', 0);
)

            )

        [1] => Array
            (
                [file] => E:\wamp64\www\mywebsite.com\online-cme\chat\lib\core\lhcore\lhmodule.php
                [line] => 116
                [args] => Array
                    (
                        [0] => E:\wamp64\www\mywebsite.com\online-cme\chat\modules\lhinstall\install.php
                    )

                [function] => include
            )

        [2] => Array
            (
                [file] => E:\wamp64\www\mywebsite.com\online-cme\chat\lib\core\lhcore\lhmodule.php
                [line] => 678
                [function] => runModule
                [class] => erLhcoreClassModule
                [type] => ::
                [args] => Array
                    (
                    )

            )

        [3] => Array
            (
                [file] => E:\wamp64\www\mywebsite.com\online-cme\chat\index.php
                [line] => 51
                [function] => moduleInit
                [class] => erLhcoreClassModule
                [type] => ::
                [args] => Array
                    (
                    )

            )

    )

[previous:Exception:private] => 
[errorInfo] => Array
    (
        [0] => 23000
        [1] => 1062
        [2] => Duplicate entry '1' for key 'lh_abstract_email_template.PRIMARY'
    )

[xdebug_message] => ( ! ) PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'lh_abstract_email_template.PRIMARY' in E:\wamp64\www\mywebsite.com\online-cme\chat\modules\lhinstall\install.php on line 1114

Call Stack
#TimeMemoryFunctionLocation
10.0010370568{main}( )...\index.php:0
20.0525444832erLhcoreClassModule::moduleInit( $params = ??? )...\index.php:51
30.0556468312erLhcoreClassModule::runModule( )...\lhmodule.php:678
40.0560481680include( 'E:\wamp64\www\mywebsite.com\online-cme\chat\modules\lhinstall\install.php )...\lhmodule.php:116
50.0737570256query( $query = 'INSERT INTO lh_abstract_email_template (id, translations, name, from_name, from_name_ac, from_email, from_email_ac, content, subject, subject_ac, reply_to, reply_to_ac, recipient, bcc_recipients, user_mail_as_sender) VALUES\n \t (1,'',\t'Send mail to user',\t'Live Helper Chat',\t0,\t'',\t0,\t'Dear {user_chat_nick},\r\n\r\n{additional_message}\r\n\r\nLive Support response:\r\n{messages_content}\r\n\r\nSincerely,\r\nLive Support Team\r\n',\t'{name_surname} has responded to your request',\t1,\t'..., $fetchMode = ??? )...\install.php:1114

)

[remdex]

Seems you failed to install and some tables were created. Now you install on top of existing database. Clean data database before installing.

[vaidyamanishjoshi]

@remdex Than for reply. I am not installing on top of existing db.
I first created db chat1, tried to install on it. It failed. So cleared / deleted all tables from it and tried again. but failed. SO i careated db chat2, chat3 and tried various times and deleting all tables in db everytime for new Install try

[remdex]

That's not true. You can see clearly here there is no duplicate records. https://github.com/LiveHelperChat/livehelperchat/blob/master/lhc_web/modules/lhinstall/install.php#L1114

So I think you did not cleared all tables.

For personal investigation there is paid support...

[vaidyamanishjoshi]

@remdex Shall I try with new database ?

[remdex]

All up to you. It's just your env problems...