collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 321
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

Welcome to SimplePortal.net! You can download SimplePortal from the Downloads Area!

Author Topic: Database Error  (Read 16282 times)

0 Members and 1 Guest are viewing this topic.

Offline candidosa2

  • Full Member
  • ***
  • Posts: 149
  • Gender: Male
  • Freelancer CMS
    • Webdesign
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
  • Elkarte Version: 1.1.3
Database Error
« on: September 16, 2008, 11:53:56 PM »
i upgrad my database and uninstall Sp install new  i see that error..


thank you






Alguma duvida pode me mandar MP que tera Suporte

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Database Error
« Reply #1 on: September 17, 2008, 12:01:52 AM »
Which versions of SimplePortal and SMF are you running?

Where are you receiving these errors?
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline candidosa2

  • Full Member
  • ***
  • Posts: 149
  • Gender: Male
  • Freelancer CMS
    • Webdesign
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
  • Elkarte Version: 1.1.3
Re: Database Error
« Reply #2 on: September 17, 2008, 12:08:37 AM »
smf 1.1.6
SP 2.04
When in home page....






Alguma duvida pode me mandar MP que tera Suporte

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Database Error
« Reply #3 on: September 17, 2008, 12:19:48 AM »
Try uninstalling and reinstalling the mod, its likely that there are some errors with the Simple Portal tables (remember to back it up). This will only work if you remove the 'sp_' tables, which will remove your data...

You could also try running this query in phpmyadmin:
Quote
ALTER TABLE {db_prefix}sp_blocks ADD force_view tinyint(2) unsigned NOT NULL default 0,

Replace '{db_prefix}' with 'smf_' or your database prefix.
« Last Edit: September 17, 2008, 12:23:51 AM by LHVWB »
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline candidosa2

  • Full Member
  • ***
  • Posts: 149
  • Gender: Male
  • Freelancer CMS
    • Webdesign
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
  • Elkarte Version: 1.1.3
Re: Database Error
« Reply #4 on: September 17, 2008, 12:52:55 AM »
where can finder that query

Code: [Select]
# mf_attachments
# Browse smf_ban_groups
# Browse smf_ban_items
# Browse smf_boards
# Browse smf_board_permissions
# Browse smf_calendar
# Browse smf_calendar_holidays
# Browse smf_categories
# Browse smf_collapsed_categories
# Browse smf_groupmods
# Browse smf_log_actions
# Browse smf_log_activity
# Browse smf_log_banned
# Browse smf_log_boards
# Browse smf_log_errors
# Browse smf_log_floodcontrol
# Browse smf_log_karma
# Browse smf_log_mark_read
# Browse smf_log_notify
# Browse smf_log_online
# Browse smf_log_polls
# Browse smf_log_search_messages
# Browse smf_log_search_results
# Browse smf_log_search_subjects
# Browse smf_log_search_topics
# Browse smf_log_topics
# Browse smf_membergroups
# Browse smf_members
# Browse smf_messages
# Browse smf_message_icons
# Browse smf_moderators
# Browse smf_package_servers
# Browse smf_pagerank
# Browse smf_permissions
# Browse smf_personal_messages
# Browse smf_pm_recipients
# Browse smf_polls
# Browse smf_poll_choices
# Browse smf_sessions
# Browse smf_settings
# Browse smf_smileys
# Browse smf_sp_articles
# Browse smf_sp_blocks
# Browse smf_sp_categories
# Browse smf_sp_functions
# Browse smf_themes
# Browse smf_topics






Alguma duvida pode me mandar MP que tera Suporte

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Database Error
« Reply #5 on: September 17, 2008, 12:55:40 AM »
The correct table is 'smf_sp_blocks' for you.
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Database Error
« Reply #6 on: September 17, 2008, 04:18:10 AM »
Just upload the file attached to you forum root and call it from your browser.
And slowly, you come to realize... It's all as it should be...

Offline candidosa2

  • Full Member
  • ***
  • Posts: 149
  • Gender: Male
  • Freelancer CMS
    • Webdesign
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
  • Elkarte Version: 1.1.3
Re: Database Error
« Reply #7 on: September 17, 2008, 08:38:06 AM »
thank you
Now she work Fine








Alguma duvida pode me mandar MP que tera Suporte

Offline Ace

  • Semi Newbie
  • *
  • Posts: 19
Re: Database Error
« Reply #8 on: September 21, 2008, 09:29:54 PM »
Hi i get same exact error

from the same location, at my homepage

heres a list of the mods i have installed:

1. SMF Arcade 2.0.15
2. Google Member Map 1.0 beta
3. SMFShop 3.0
4. SMF Shop Lottery 1.0 
5. Welcome Topic Mod 1.1 
6. audiblepm 1.5 1.5 
7. leaders 1.0 
8. simplemp 3.1 
9. SMFPets 0.2 
10. MoodBobels 2.1 
11. SMF 1.0.14 / 1.1.6 Update 1.0 
12. SMF Shop - Jeeves The Butler 1.0.2 
13. Custom_Greeting_Depending_on_Time 0.4 
14. Tar Game Uploader 1.0 
15. Global Headers Footers 1.4.1 
16. Metal Gear Avatars 1.0 
17. Futurama Avatars 1.0 
18. Gaming Avatars 1.0 
19. NHL Team Logos 1.0 
20. Invite 1.14 
21. SMFShop Inventory Post Mod 0.2 
22. Global Announcements 1.0 
23. The Simpsons Avatars 1.0 
24. SMFChess 1.0 
25. Paid Subscriptions 0.18 
26. Colorized Membergroups 1.0 
27. SMF Arcade Shop Mod 1.0.0
28. Streaming 3 4.2.2b
29. VisualWarning 1.42 
30. Colorize Boards 3.0 
31. Reg Bar 1.0.2
32. RSS Feed Icon 1.1 
33. Shop Item: Profile Image 0.1 
34. Password Protect Boards 0.2 
35. SMF Arcade Trophies Mod 1.1.1
36. Affiliates 1.1 
37. SimplePortal 2.0.4
« Last Edit: September 21, 2008, 09:33:45 PM by Ace »

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Database Error
« Reply #9 on: September 21, 2008, 09:37:26 PM »
Have you tried running the 'upgrade.php' file attached to [SiNaN]'s post?
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline Ace

  • Semi Newbie
  • *
  • Posts: 19
Re: Database Error
« Reply #10 on: September 22, 2008, 08:30:18 AM »
Have you tried running the 'upgrade.php' file attached to [SiNaN]'s post?

Yes, but it didnt work

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Database Error
« Reply #11 on: September 22, 2008, 08:33:01 AM »
Okay, what errors are you receiving in your forum error log?
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline Ace

  • Semi Newbie
  • *
  • Posts: 19
Re: Database Error
« Reply #12 on: September 22, 2008, 09:57:54 AM »
Okay, what errors are you receiving in your forum error log?

These are the errors

8: Undefined index: pets
File: /home/snake/public_html/forum/Sources/Load.php
Line: 1203

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: gameDirectory
File: /home/snake/public_html/forum/Themes/default/SPortal.template.php (main sub template - eval?)
Line: 79

8: Undefined index: arcade_mins
File: /home/snake/public_html/forum/Sources/ArcadeStats.php
Line: 275

8: Undefined index: arcade_hours
File: /home/snake/public_html/forum/Sources/ArcadeStats.php
Line: 274

8: Undefined index: arcade_days
File: /home/snake/public_html/forum/Sources/ArcadeStats.php
Line: 273

8: Undefined index: arcade_weeks
File: /home/snake/public_html/forum/Sources/ArcadeStats.php
Line: 272

Database Error: 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 'CHAR_LENGTH(b.passwd) = 0
AND approved = 1
AND publish = 1' at line 6
File: /home/snake/public_html/forum/Sources/SPortal.php
Line: 132

2: Cannot modify header information - headers already sent by (output started at /home/snake/public_html/smf/index.php:83)
File: /home/snake/public_html/forum/Sources/Subs.php
Line: 3396

2: Cannot modify header information - headers already sent by (output started at /home/snake/public_html/smf/index.php:83)
File: /home/snake/public_html/forum/Sources/Subs.php
Line: 3393

2: Cannot modify header information - headers already sent by (output started at /home/snake/public_html/smf/index.php:83)
File: /home/snake/public_html/forum/Sources/Subs.php
Line: 3387

2: Cannot modify header information - headers already sent by (output started at /home/snake/public_html/smf/index.php:83)
File: /home/snake/public_html/forum/Sources/Subs.php
Line: 3386

2: Cannot modify header information - headers already sent by (output started at /home/snake/public_html/forum/index.php:83)
File: /home/snake/public_html/forum/Sources/Load.php
Line: 2033

2: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cache limiter - headers already sent (output started at /home/snake/public_html/forum/index.php:83)
File: /home/snake/public_html/forum/Sources/Load.php
Line: 2029

2: Cannot modify header information - headers already sent by (output started at /home/snake/public_html/forum/index.php:83)
File: /home/snake/public_html/forum/Sources/Subs.php
Line: 3290


theres 15 pages all together

I can give you access if you like...

Offline Runic

  • The Traveller
  • Marketer
  • *
  • Posts: 414
  • Gender: Male
    • BryanDeakin.com
  • SMF Version: 2 RC3
  • SP Version: None
Re: Database Error
« Reply #13 on: September 22, 2008, 01:47:03 PM »
im curious are you running it while logged in?
Bryan Runic Deakin
|
??????? Po???? ??????
Marketing
|
??????????

Offline asude

  • Jr. Member
  • **
  • Posts: 54
  • Gender: Female
Re: Database Error
« Reply #14 on: September 22, 2008, 02:10:03 PM »
turn off the Arcade block, you probably have a different version than portal supports.

and to people developing this, it could be also about this error:

Code: [Select]
Database Error: 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 'CHAR_LENGTH(b.passwd) = 0
AND approved = 1
AND publish = 1' at line 6
File: /home/snake/public_html/forum/Sources/SPortal.php
Line: 132

i guess it is Password Protect Boards by Dragooon. it modifies the $user_info['query_see_board'] and you use it in article query. maybe a conflict or maybe a problem caused by that mod.

Offline Ace

  • Semi Newbie
  • *
  • Posts: 19
Re: Database Error
« Reply #15 on: September 22, 2008, 02:25:21 PM »
Yes im loggin and when i go to homepage its there, when i log out its there..but only on homepage.

Offline Ace

  • Semi Newbie
  • *
  • Posts: 19
Re: Database Error
« Reply #16 on: September 22, 2008, 02:29:21 PM »
turn off the Arcade block, you probably have a different version than portal supports.

and to people developing this, it could be also about this error:

Code: [Select]
Database Error: 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 'CHAR_LENGTH(b.passwd) = 0
AND approved = 1
AND publish = 1' at line 6
File: /home/snake/public_html/forum/Sources/SPortal.php
Line: 132



i guess it is Password Protect Boards by Dragooon. it modifies the $user_info['query_see_board'] and you use it in article query. maybe a conflict or maybe a problem caused by that mod.


Yes you are correct!!! it was that password board mod... i uninstalled it and everything came back... THANKS!!!
« Last Edit: September 22, 2008, 02:30:53 PM by Ace »

Offline asude

  • Jr. Member
  • **
  • Posts: 54
  • Gender: Female
Re: Database Error
« Reply #17 on: September 22, 2008, 02:39:06 PM »
actually i tested and didn't get any problems. no conflict. don't know what happened but i'm sure it is about $user_info['query_see_board']. maybe there was a problem with installation of the other mod.

Offline Ace

  • Semi Newbie
  • *
  • Posts: 19
Re: Database Error
« Reply #18 on: September 22, 2008, 02:45:04 PM »
I now only have this error still showing..

8: Undefined index: pets
File: /home/snake/public_html/forum/Sources/Load.php
Line: 1184


Offline Eliana Tamerin

  • Comrade
  • *
  • Posts: 2889
  • Gender: Female
  • SMF Version: 2 RC2
  • SP Version: 2.3.2
Re: Database Error
« Reply #19 on: September 22, 2008, 02:46:00 PM »
That's unrelated to SimplePortal. My guess is you have SMF Shop installed, with the SMF Pets addon. I'd suggest reporting that error to the Pet's author.
Ms. Eliana TamerinIt should be painfully obvious by now that I don't respond to support PMs. Don't send me PMs for support. They will be ignored and deleted, post on the Support Boards to get support.