letractively / osclass Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/osclass
Automatically exported from code.google.com/p/osclass
the "post your ad" works in theme1 (blue one) but doen't work in theme2
(pink one)
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 4:59
My URL is:
http://localhost/osclass/animals-cat-9
It returns me a 404 Error.
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 5:02
What steps will reproduce the problem?
1. On step 3 of installation (Basic configuration) DO NOT select any of
categories.
2. This will leade to warning on step 4: Warning: implode()
[function.implode]: Invalid arguments passed in /home/maksim/Aptana Studio
Workspace/osclass/webapp/oc-installer/index.php on line 83
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 ')' at line 1
3. Because of this warning/error admin account won't be created.
What is the expected output? What do you see instead?
In case of not selecting any of categories it must create admin user
anyway. Plus, I think, it should create basic set of categories anyway by
default, just in case if user won't select any of them.
Original issue reported on code.google.com by [email protected]
on 2 Feb 2010 at 4:20
What steps will reproduce the problem?
1. Try to register user with the same login name.
2. Check in database in oc_user table.
3.
What is the expected output? What do you see instead?
Error message is expected.
Please use labels and text to provide additional information.
username column must be set to UNIQUE.
Original issue reported on code.google.com by [email protected]
on 4 Feb 2010 at 8:59
[deleted issue]
- The source code: utf-8
- The database: utf-8
- website in utf-8
Now the database is latin-1
Original issue reported on code.google.com by danielgs
on 20 Jan 2010 at 9:32
The order of the categories should be:
- cat1
- subcat11
- subcat12
- subcat13
- cat2
- cat3
- subcat31
- subcat32
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 12:11
What steps will reproduce the problem?
1. Post new item
2. Put price 500
3. Access item on a web page. Price is 500.000
What is the expected output? What do you see instead?
Expected output is 500
Please use labels and text to provide additional information.
Price column type in MySQL should be changed to FLOAT(9,2) instead of
FLOAT(9,3)
Original issue reported on code.google.com by [email protected]
on 2 Feb 2010 at 11:38
What steps will reproduce the problem?
1. Now during installation password stored as encrypted string.
2. If you change password in admin panel, it is stored as it is.
Original issue reported on code.google.com by [email protected]
on 3 Feb 2010 at 8:13
What steps will reproduce the problem?
1. Try to add new item
2. If directory is not writable, we get 3 warnings from PHP
Warning:
move_uploaded_file(/Users/max/Projects/osclass/webapp/oc-content/uploads/1)
[function.move-uploaded-file]: failed to open stream: Permission denied in
/Users/max/Projects/osclass/webapp/item.php on line 152
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move
'/Applications/XAMPP/xamppfiles/temp/phpLwHaMd' to
'/Users/max/Projects/osclass/webapp/oc-content/uploads/1' in
/Users/max/Projects/osclass/webapp/item.php on line 152
Warning: Cannot modify header information - headers already sent by (output
started at
/Users/max/Projects/osclass/webapp/item.php:152) in
/Users/max/Projects/osclass/webapp/oc-includes/osclass/utils.php on line 4
3.
What is the expected output? What do you see instead?
See message that directory is not writable, or even better, check if it is
writable during
installation.
Please use labels and text to provide additional information.
Original issue reported on code.google.com by [email protected]
on 24 Feb 2010 at 10:04
[deleted issue]
In the "success!" page, you need a link for the "admin page login"
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 11:11
I couldn't change title and description of my web page.
Original issue reported on code.google.com by [email protected]
on 3 Mar 2010 at 3:50
- Stats system:
- Number of items (backoffice dashboard), items by category
- Number of registered users
Original issue reported on code.google.com by danielgs
on 19 Jan 2010 at 3:37
Work in this 2 functions to retrieve:
- The active countries in the classifieds site ( like O L X )
- Last items to put them (i.e. in the home page): get_last_items(cat_id,
total_items)
Original issue reported on code.google.com by [email protected]
on 30 Mar 2010 at 3:15
Admin password (and all passwords) should be stored as encrypted string.
Right now it is a plain text string.
Original issue reported on code.google.com by [email protected]
on 2 Feb 2010 at 4:58
What steps will reproduce the problem?
1. Add item and specify location for it
2. Delete item from administrator.
3. Check oc_location table - info is still there!
What is the expected output? What do you see instead?
All info should be removed. Also it is better not to set AUTO INCREMENT on
oc_location 'id' row.
Original issue reported on code.google.com by [email protected]
on 3 Mar 2010 at 4:27
The config.php have
define('WEB_PATH', '') ;
I think the new config.php need to have your own domain (and directories if
you are using them). In my case:
define('WEB_PATH', 'http://localhost/osclass');
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 4:58
<?php
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASSWORD', '');
define('DB_NAME', 'osclass_db');
define('DB_TABLE_PREFIX', 'oc_');
$f = str_replace( "\\", "/", __FILE__ ); // para que funcione en Windows
if( preg_match( "|^(.*[\\/])([^\\/]+-?)$|", $f, $matches ) ) { $PATH_BASE =
$matches[1] ; }
define('PATH_BASE', $PATH_BASE) ;
//DIR_NAME ha de salir del installer...
define('DIR_NAME', 'osclass') ;
define('WEB_PATH', 'http://' . $_SERVER['HTTP_HOST'] . '/' . DIR_NAME) ;
?>
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 11:51
Changes in the installer:
- Check text when you are speaking about the rename of the config-sample.php
- Check other texts
- Redirect in the index.php when the app is not installed yet
- Recode the index.php when the app is installed
- In the last step, before "run the install", show the config-sample.php to
the user, if the file is correct, you can rename the file to the definitive
name.
- (fase 2) If you want you can do a file editor for the config.php
- The step where you are is important from the first screen til de last...
Put the steps at the top and then in another color where you are.
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 11:02
If I try to update a category from here:
http://localhost/osclass/oc-admin/categories.php?parentId=2
I click at "edit" in any category:
http://localhost/osclass/oc-admin/categories.php?action=edit&id=31
And I have the same filled form, independetly of the category clicked. (I
think always I have filled the "Name" field with the value "Jobs"
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 5:16
What steps will reproduce the problem?
1. http://localhost/osclass/oc-admin/p-settings.php
2. http://localhost/osclass/oc-admin/main.php
3. http://localhost/osclass/oc-admin/categories.php and other pages
What is the expected output? What do you see instead?
1. http://localhost/osclass/oc-admin/settings.php {maybe}
2. there isn't the click on "Tools" - is inactive
3. I can;t add category or state or other - all ceckbox seem inactive
What version of the product are you using? On what operating system?
Win xp-pro : localhost - php 5.1.3 [flock - Seamonkey]
osclass1.0.alpha
Please provide any additional information below.
is impossible to use at the moment to ceck and add other idea or design.
Original issue reported on code.google.com by [email protected]
on 15 Feb 2010 at 11:41
another step, after the categories selection is the selection of the
country. You have 3 options in this step:
- selection of a country:
- all the countries -> with all their regions
- one country:
- If you select "one country". 2 options:
- You can check some regions in that country (with checkboxes)
- Select all -> you have a classifieds website
in that country (with all the regions)
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 5:50
Change relative paths to absolute paths in the web source.
ie: <a href="items.php">Items</a><br />
<a href="<? echo WEB_PATH ?>/oc-admin/items.php">Items</a><br />
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 11:59
The installation was successful: now I have renamed the installation
directory. I'm trying to log in the backoffice but I obtain this fatal error:
Fatal error: Call to undefined function genRandomPassword() in
/Applications/XAMPP/xamppfiles/htdocs/osclass/oc-admin/index.php on line 59
I have selected all the categories in the 3rd step of the installation
process but when I try to visit de main page, there is no categories. Is
that normal?
I'm using the last code of the repository.
Original issue reported on code.google.com by [email protected]
on 21 Mar 2010 at 7:02
We still have a lot of relative paths in the source code. However, I have
in my config.php file:
define('WEB_PATH', 'http://localhost/osclass');
In the source code at the home:
In that place:
<div style="float: right;">
<a class="Lang" href="?action=setlanguage&value=es_ES">español</a> |
<a class="Lang" href="?action=setlanguage&value=en_US">english</a>
</div>
And in that place:
<a href="item.php?action=post">Publish your item</a>
In the source code at the "add your item":
<form action="item.php" method="post" enctype="multipart/form-data">
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 5:08
I think you speak in some places of the source code about "recover" the
password. The recovery is impossible because is encoded as a md5 string,
isn't it? I think is a "restoration" of the password...
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 4:41
What steps will reproduce the problem?
1. I istalled fresh copy of osclass
2. Empty table country
3. Add other values for country
What is the expected output? What do you see instead?
When i try to add a post i get the message "Cannot add or update a child
row: a foreign key constraint fails"
What version of the product are you using? On what operating system?
Beta version
Please provide any additional information below.
You can try at www.cupoanerabla.ro
Original issue reported on code.google.com by [email protected]
on 15 Mar 2010 at 3:39
Now I'm not logged in but I used that checkbox.
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 4:42
Send an email when you have finished the installation width the login
(admin) and the password for the administrator. Also, as in wordpress, is
interesting that we explain to the user the importance of changing the
password.
For instance, I don't remember my admin password and I don't have it in my
email.
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 4:39
In the category page I obtain these warnings:
Notice: Undefined index: ocTriggers in
/Applications/XAMPP/xamppfiles/htdocs/osclass/oc-content/themes/large/footer.php
on line 7
Warning: Invalid argument supplied for foreach() in
/Applications/XAMPP/xamppfiles/htdocs/osclass/oc-content/themes/large/footer.php
on line 7
Original issue reported on code.google.com by danielgs
on 2 Feb 2010 at 4:51
What steps will reproduce the problem?
1. Install osclass without any preffix for tables
What is the expected output? What do you see instead?
Fatal error: Uncaught exception 'DatabaseException' with message 'Table
'os_nitbcn.oc_category' doesn't exist' in /var/www/osclass/webapp/oc-
includes/osclass/db.php:96 Stack trace: #0 /var/www/osclass/webapp/oc-
admin/main.php(18): dbFetchResults('SELECT c.id, c....') #1 {main} thrown
in /var/www/osclass/webapp/oc-includes/osclass/db.php on line 96
Please use labels and text to provide additional information.
I will try more use cases, like try another preffix.
Original issue reported on code.google.com by [email protected]
on 3 Mar 2010 at 12:55
What steps will reproduce the problem?
1. Fresh install
2. Do not create empty osclass in mysql database
3.
What is the expected output? What do you see instead?
I was expecting that script will create database (osclass_db) for me
What version of the product are you using? On what operating system?
Latest from svn repository
Please provide any additional information below.
I think that installation script must try to create DB in case if it does
not exist
Original issue reported on code.google.com by [email protected]
on 25 Jan 2010 at 3:33
::::::::::::::::::::
:::::Backoffice:::::
::::::::::::::::::::
* ITEMS
- Add new item
- Manage items
- In this screen, you can delete item, delete comments for
the item, modify items, modify comments for the item
* CATEGORIES
- Add new category
- Manage categories (you can select the parent category. There are only 2
levels)
* COMMENTS FOR THE ITEMS
(you can decide if you want comments for this kind of items -this category-
or not)
- Manage comments (in general, without select an item, ordered by date desc)
* THEMES (selected theme, import theme from wp and available themes,
similar to wordpress)
* PLUGINS
- Add new
- Manage plugins (you can activate a plugin or edit the code of the plugin
directly)
* USERS (web users)
- Add
- Manage (delete, edit)
* GENERAL OPTIONS
- Change the name
- Change the claim
- Change the logo
- GMT (important by country). if you put any GMT here everything works with
that one.
- Date format (important by country). If you put any date format here
everything works with that one. One option could be, personalized with an
input text...
- Time format (important by country). If you put any date format here
everything works with that one. One option could be, personalized with an
input text...
- The week starts in... ( ie. "Monday" )
* At the TOP RIGHT of the page (that is design, is not important now), you
have the admin's name, that is linking to the administrator settings and
you can edit them. And the logout like in wordpress. Only the
super-administrator (the first administrator) can create other
administrators for the backoffice (oc-admin), then, the super-administrator
could have another option. Something like:
ADMINISTRATOR
- add administrator
- manage administrator
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 4:22
[deleted issue]
Normally we are working with items in another database technology, or
without database (using for example, excel or csv).
We can do a data importer, just to pass the data to our database. The user
provide us the name of the table that has the items, and match the name of
its fields to our fields.
FASE 2: We can match also the categories with our categories.
Note that the important thing is to make easy the import of everything from
another technologies to our technology
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 12:30
What steps will reproduce the problem?
1. /item.php?id=[ insert SQLi without the brackets]
2.
3.
What is the expected output? What do you see instead?
admin password is displayed, as well as other information depending
on the sql injection used
What version of the product are you using? On what operating system?
Version 1.1.0A
Please provide any additional information below.
Just follow in the recently published exploit.
http://www.exploit-db.com/exploits/11496
Original issue reported on code.google.com by [email protected]
on 18 Feb 2010 at 4:49
I'm trying to install osclass at http://localhost/osclass and when i have
finished the installation, I have to change the config.php to assign the
value of WEB_PATH to "http://localhost/osclass".
The email I received was:
Congratulations! Your OSClass installation at http://localhost is up and
running. You can access the administration panel with the username "admin"
and password "wqf3hp7h".
But the correct URL in my case was, "http://localhost/osclass"
Original issue reported on code.google.com by danielgs
on 3 Feb 2010 at 12:45
Do not show database parameters in the URL during installation.
Use POST instead.
Original issue reported on code.google.com by [email protected]
on 2 Feb 2010 at 1:23
One of the steps is the selection of the categories using checkboxes... by
default you have everything checked and you can uncheck what you want.
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 12:04
[deleted issue]
:::::::::::::::::::::::::::::
::CHANGES IN THE DATA MODEL::
:::::::::::::::::::::::::::::
* WARNING
- I don't understand the syntax you are using to create the name of the
fields. Taking a look in the data model I should know what fields are
"foreign keys" (and of what table). Another important thing is to know the
"data type". ie. we can use at the beginning of the fields that preffix:
* varchar, mediumtext, bigtext, with malloc : "s_"
* char, works different with the memory: "c_"
* integer, long: "i_"
* boolean [ int(1) ] : "b_"
* decimal, float: "f_"
* datetime: "dt_"
* date: "d_"
* timestamp: "ts_"
- field names, table names and index names: always lower case and
descriptive names
- ie: the definition of "category" (the name "t_category") but the name of
the fields:
* i_id
* s_name
* s_description
* fk_i_id_category (fk_<referred_field_name>_<what_table>)
MORE FIELDS IN THE TABLES AND REESTRUCTURATION...
::ad:: -> the name "t_ad"
id -> ok, the name i_id
pub_date -> ok, the name dt_date
update_date -> needed, the name dt_update_date
category_id -> ok, the name fk_i_id_category
price -> ok, the name f_price
title -> ok, the name s_title
description -> ok, the name s_description
location_id -> no, I don't understand this field
num_views -> no, we need more tables with statistics... fase 2 -> we can
study if is needed that field desnormalized in that table
fk_i_id_t_countries -> the country. Foreign key of t_countries.
s_country -> I'm not sure if we need that field desnormalized.
fk_i_id_t_regions -> the region. Foreign key of t_regions (default value 0)
s_region -> the name desnormalized of the region (important for performance)
fk_i_id_t_cities -> the city. Foreign key of t_cities (default value 0)
s_city -> the name desnormalized of the city (important for performance and
just in case we don't have in our table the inserted city)
s_city_area -> the name of the neighbourhood (is impossible to do a table
with all the city areas in the world)
:LOCATION: -> deprecated :P I don't understand your idea of have the
location of the item in another table because all the items must be
geolocalizated.
:t_cities:, :t_regions:, :t_countries: -> needed. Fill those tables using
geonames.org
:ad_comment: (t_ad_comment)
id -> ok. i_id
dt_date -> needed
ad_id -> ok. fk_i_id_t_ad
author_name -> ok. s_author_name
author_email -> ok. s_author_email
body -> ok. s_body
b_active -> needed. b_active can be a int(1). The default should be 1 but
you can deactivate form the backoffice. At the backoffice you can select if
you want email validation by user or not.
b_spam -> needed. b_spam can be a int(1). The default value should be 0 but
you can mark it at the backoffice (or a plugin like akismet).
:ad_resource: -> what is that?
:user: -> we need 2 tables. First for us (backoffice) and the other for the
web users
:preference, page, and module: -> I cannot define them very well now. I
need to speak with you.
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 5:05
When I enter in the "settings options" I obtain this notice at the "page
title" field:
<br /> <b>Notice</b>: Undefined index: pageTitle in
<b>/Applications/XAMPP/xamppfiles/htdocs/osclass/oc-admin/settings/default.php</
b>
on line <b>21</b><br />
Original issue reported on code.google.com by danielgs
on 3 Feb 2010 at 12:51
The config.php file that is automatically generated, doesn't have the close
php tag at the end of the file ( ?> )
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 11:31
- Put the "remember my password in this computer"
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 11:22
Is interesting to have information about who is installing the osclass
code. In last installation's step we should register this information in
the osclass.org database.
We can pass all this information via HTTP-GET to a PHP script created in
osclass.org. This script can save the information (to know how many people
install the code and how many people finally use the code in a real project)
Original issue reported on code.google.com by [email protected]
on 21 Mar 2010 at 6:55
What steps will reproduce the problem?
1. Change in admin to OSClass large 1 theme
2. Open OSClass in your browser (mine is http://localhost/osclass/
3. Click on a page title.
What is the expected output? What do you see instead?
Expected to stay on http://localhost/osclass/ although I was sent to
http://localhost/ instead
Original issue reported on code.google.com by [email protected]
on 3 Feb 2010 at 8:52
What steps will reproduce the problem?
1. Change language to any of them.
2. Login to admin panel.
3. Menu is in language that you have selected on frontpage.
What is the expected output? What do you see instead?
Language settings should be separate for frontpage and admin/user panel
Please use labels and text to provide additional information.
Original issue reported on code.google.com by [email protected]
on 15 Mar 2010 at 11:23
Once the installation is finished, (for example, we can test if the new
index.php exists) the _installer shouldn't work, the best option is a page
showing that the installation is already done and that if you want you can
delete the "_installation" directory.
Original issue reported on code.google.com by danielgs
on 18 Jan 2010 at 12:52
What steps will reproduce the problem?
1. Install new site and change default table prefix to something other than oc_
2. Try and use the site by logging in as admin
There's onlu a few files. Find them with:
rgrep oc_ * |grep SELECT
from install root
Original issue reported on code.google.com by [email protected]
on 3 Mar 2010 at 5:40
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.