eldoba / fusioncms Goto Github PK

After 6f16ef5
while installing fusion, the default avatar isn't correctly shown

Describe the bug
After 6f16ef5
while installing fusion, the default avatar isn't correctly shown

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
Add any other context about the problem here.

Did you help close this issue? Go claim the $10 bounty on Bountysource.

Error Number: 1054

Unknown column 'sha_pass_hash' in 'field list'

INSERT INTO account (username, sha_pass_hash, email, expansion, last_ip, joindate) VALUES ('sdssada', 'c2e64a54dfad3b64f31533f11ded90207d6dba29', '[email protected]', '2', '5.117.220.244', '2021-05-01')

Filename: /home/trabes/domains/public_html/models/external_account_model.php

Line Number: 133

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
Add any other context about the problem here.

The $5 bounty on this issue has been claimed at Bountysource.

Describe the bug
Incorrect operation of 404.

When you try to go to a non-existent site page (for example site.com/askdjaksjdk), there is a huge number of requests to the database, such as:

SELECT * FROM sideboxes ORDER BY `order` ASC

Collected the system call log, and it look like this:

\0\0\4\3def\fhaeniken_1si\tsideboxes\tsideboxes\vdisplayName\vdisplayName\f!\0\375\377\2\0\374\20\0\0\0\0J\0\0\5\3def\fhaeniken_1si\tsideboxes\tsideboxes\vrank_needed\vrank_needed\f?\0\n\0\0\0\3\t@\0\0\0>\0\0\6\3def\fhaeniken_1si\tsideboxes\tsideboxes\5order\5order\f?\0\v\0\0\0\3\0\0\0\0\0H\0\0\7\3def\fhaeniken_1si\tsideboxes\tsideboxes\npermission\npermission\f!\0\226\0\0\0\375\0\0\0\0\0\5\0\0\10\376\0\0\"\0\34\0\0\t\0012\ninfo_login\tUser area\0012\0011\373\34\0\0\n\0011\6status\rServer status\0011\0012\373\32\0\0\v\0013\10shoutbox\tShout box\0011\0013\373\5\0\0\f\376\0\0\"\0", 32768, MSG_DONTWAIT, NULL, NULL) = 539 <0.000016>
22:20:14.382542 [ 7f9c41a7b247] access("application/modules/sidebox_info_login/controllers/info_login.php", F_OK) = 0 <0.000024>
22:20:14.382623 [ 7f9c41a7bc02] getcwd("/home/h/haeniken/blablablawow/public_html", 4096) = 49 <0.000015>
22:20:14.382758 [ 7f9c41a7a775] stat("application/modules/asdasdasda", 0x7fff640772a0) = -1 ENOENT (No such file or directory) <0.000019>
22:20:14.382842 [ 7f9c41a7b247] access("application/themes/default/modules/error/error.tpl", F_OK) = -1 ENOENT (No such file or directory) <0.000019>
22:20:14.382984 [ 7f9c41a7bc02] getcwd("/home/h/haeniken/blablablawow/public_html", 4096) = 49 <0.000015>
22:20:14.383072 [ 7f9c41d6d96a] sendto(11, "-\0\0\0\3SELECT * FROM sideboxes ORDER BY `order` ASC", 49, MSG_DONTWAIT, NULL, 0) = 49 <0.000021>
22:20:14.383150 [ 7f9c41a7fbc4] poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 86400000) = 1 ([{fd=11, revents=POLLIN}]) <0.000070>
22:20:14.383270 [ 7f9c41d6d7ea] recvfrom(11, "\1\0\0\1\0068\0\0\2\3def\fhaeniken_1si\tsideboxes\tsideboxes\2id\2id\f?\0\v\0\0\0\3\3B\0\0\0<\0\0\3\3def\fhaeniken_1si\tsideboxes\tsideboxes\4type\4type\f!\0\226\0\0\0\375\1\0\0\0\0J

And it can be really problem - 10444 selects:

$ cat log_2021-02-10_22-20-14.12571 | grep -i select | grep -i sideboxes | wc -l
10444

$curl -L -q -o /dev/null -w "\nConnect: %{time_connect}\nTTFB: %{time_starttransfer}\nTotal time: %{time_total} \n" https://blablablawow/asdasdasd
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 232 0 232 0 0 68 0 —:--:— 0:00:03 —:--:— 72
100 20267 0 20267 0 0 5817 0 —:--:— 0:00:03 —:--:— 5817

Connect: 0,000
TTFB: 0,118
Total time: 3,484

After off all modules with 'Sidebox` name, it not fixed.

Hi there first of all thanks for the nice cms!

but unfortunately i can't open the forum.
I get the following error.

Something went wrong!

Technical data:
Fatal error: Cannot declare class Error, because the name is already in use in C:\xampp\htdocs\application\modules\error\controllers\error.php on line 3

And sometimes at realm status I also get the following error

A PHP Error was encountered
Severity: Warning

Message: count(): Parameter must be an array or an object that implements Countable

Filename: libraries/realms.php

Line Number: 201

Do you have a solution for this? Greetings Stijn

Hi, i have found a wow server. When i reigster to web site i can register on site but i cant to server. I have take a error page. Error screenshot is attached. Please help.

my site: http://worldofwarcraftprime.com

Thanks.

Describe the bug
At some stage of the formation of the page of a non-english-language nickname of a character with a letter link, an error occurs.

Steps to reproduce the behavior:

1. Create non-english-language nickname of charaster
2. Go to 'User panel'
3. Click on icon of this charaster
4. See error

English-language nickname feels good

Screenshots

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Installer'
2. Do all steps until installation shoud Writing configs
3. Installer stucks @ Writing configs...
4. Nothing happens. No database entries after 15 minutes.

ISSUE
Up on installation:
validation errors does not appear on UI so I dumped data and discovered that

• Input names on install/database page are irrelevant to what validation rules ar expecting; i.e input name is db_name while validation rule is excpecting db_database and hence neither error is shown on UI nor the installation procceeds.

RESOLUTION
Just find installation controller and view files under vendor/fusioncms/ and change input names accordingly.

ISSUE
When on local, most of the times the database does not have password a.k.a the password is blank. Since the fusioncms has set a default password for database as 'secret' when no password is provided the connection is not possible and you can see the output only in log files not on UI.

RESOLUTION
Delete 'secret' database password from fusioncms database installer controller.
And you also need to remove 'required' validation for databse password on both install/databse view file and install/confirm view file if you want to connect with blank password.

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 = 1' at line 1

UPDATE account SET 0 = 1

Filename: C:/xampp/htdocs/system/database/DB_driver.php

Line Number: 656

bnetaccounts u need to edit yourself than u can login into game it will not auto adding the agrements